#Error

[kbreiss]

I am receiving a #Error in a textbox of which I'm attempting to get my data from a DLookUp() function.

Here is what I have in the textbox's ControlSource.........
=DLookUp("[ADDRESS]","FACILITY","[FAC_ID] =" & [Forms]![Appointment]![COMBO12])

When I test the second part of this function in the ControlSource.... = [Forms]![Appointment]![COMBO12]) I get the Fac_ID...which is right.

I don't know if I have something wrong with the first part of the function or what??


Any advice is greatly appreciated.
Thanks,
Kacy
________
Lovely Wendie99

 

[kbreiss]

I surprised myself and figured this one out on my own. I looked in a book and it gave a little different syntax that the help file in access and it worked.

Here's the difference in syntax.....
=DLookUp("[ADDRESS]","[FACILITY]","[FAC_ID] = [Forms]![Appointment]![COMBO12]")

Kacy
________
LovelyWendie