Auto populate field in Form - more complicated than the title suggests

[ohrschool]

My knowledge is limited (my apologies).
Is there a way to autopopulate a field in a form using a where condition in a macro?

Once Field_1 is filled I need Field_2 to be populated with a value (taken from another table) using a macro.
Can setValue be used with a where condition in order to determine the expression in setvalue?



Thanks

[pbaldy]

Well, you could use DLookup(). Or perhaps this is appropriate?

http://www.baldyweb.com/Autofill.htm