DLookup Function

[hirenJ]

Hey all,

I have a form that contains a CodeID -- However, I want the JobFunction that corresponds to the CodeID to be displayed each time the form loads -- im using the DLookup function -- However -- how can I set the criteria to a txtBox that is on my form ??

DLookup("JobFunction", "RespCodes", "[CodeID = (txtBox?)]&quot

Is this possible, and what would the syntax be?

Cheers

Hj

)

 

[JoeMiller]

=DLookup("JobFunction", "RespCodes", "[CodeID]="&[txtBox]&&quot"

That will work if the CodeID is a number. If it's a string you'll need this:

=DLookup("JobFunction", "RespCodes", "[CodeID]='"&[txtBox]&"')"

HTH Joe Miller
joe.miller@flotech.net