Hello,
I have a combo box that hides the primary id and displays the Facility Name.
When a facility name is clicked on I would like for it to automatically look up the facility manager. Here is the DLookUp code that I am running now, but nothing is happening.
=DLookUp("[MANAGER]","[FACILITY]","[FAC_ID] = [Forms]![Appointment]![COMBO12]")
Does anyone have any idea how looking up the facility manager could be acheived.
Thanks in advance,
Kacy
________
HONDA CB1000
I have a combo box that hides the primary id and displays the Facility Name.
When a facility name is clicked on I would like for it to automatically look up the facility manager. Here is the DLookUp code that I am running now, but nothing is happening.
=DLookUp("[MANAGER]","[FACILITY]","[FAC_ID] = [Forms]![Appointment]![COMBO12]")
Does anyone have any idea how looking up the facility manager could be acheived.
Thanks in advance,
Kacy
________
HONDA CB1000
Last edited: