Select statement output to variable

[joyaccess1]

Hi,
In a form i need to disable the fields based on the value from the parent table, i am planning to write a event procedure to execute an select statement and then compare the value returned from the select statement to enable or disable fields in the form.

I am unable to figure out how to assign the rows(returned value) from the select statement into a variable in the event procedure, any help on how i can do this (assign the return value from the select into a variable) will be helpful

Thanks
Joy

 

[RuralGuy]

Look at the DLookup() function.

 

[joyaccess1]

Thanks, got it.

 

[RuralGuy]

Great! And you are welcome.