Array

[Ezekiël]

Hi,

Can someone help me with creating an array?

I would like to compare strings which are typed in a textbox with a list of
values stored in a seperate table. For example: if a number is typed in the
textbox like 123456, then after update it must lookup the value in another
table for if it exist. If it exist then allow the typed value to be saved,
if not a message or something else may appear.

How can i achieve this?

Greetings,

Ezekiël

 

[Dev Ashish]

if a number is typed in the
textbox like 123456, then after update it must lookup the value in
another table for if it exist. If it exist then allow the typed value
to be saved,

Look at 'DLookup' in Help. Use the AfterUpdate event to perform the lookup
and cancel the typed value if necessary.

-- Dev