Hi I have a form where i have a dropdown box. The user selects either:
No
Yes-Observer
Yes-Technician
The table (LU Observer Present Lookup) that is used for the dropdown box has three fields:
ID
Observer Database Code (a number)
Observer_Present (text)
The Observer Present column is what the user selects on the form. I want to write a code that selects the Database Code that corresponds to the Observer Present selected. The ID field is the same for both entries.
I tried using Dlookup- but am not getting results
Private Sub OBSERVER__PRESENT_AfterUpdate()
Dlookup("OBSERVER DATABASE CODE",
"LU OBSERVER PRESENT LOOKUP","[ID]=
FORMS!OBSERVER PRESENT")
End Sub
Thanks for any help