Array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
Click to expand...

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

-- Dev
 
Back
Top