G
Guest
I've set up a main form "Companies" with the city field using a DLookUp
expression, and it works fine. Here it is...
=DLookUp("[City]","Zip Codes","[ZipCode]='" &
Forms!Companies!SitessubformControl!PhysicalZip & "'")
Here's the problem. I am also wanting to use a similar expression in a
subform "Sites". Here's the expression I'm trying to use...
=DLookUp("[City]","Zip Codes", "[ZipCode]= '" & Forms![Companies]![Sites
subform]![PhysicalZip] & "'")
I have tested the different parts of the expression, and the separate parts
work fine. When I put it all together, I get a Null value returned.
Can anyone tell me what I'm doing wrong?
Thanks.
expression, and it works fine. Here it is...
=DLookUp("[City]","Zip Codes","[ZipCode]='" &
Forms!Companies!SitessubformControl!PhysicalZip & "'")
Here's the problem. I am also wanting to use a similar expression in a
subform "Sites". Here's the expression I'm trying to use...
=DLookUp("[City]","Zip Codes", "[ZipCode]= '" & Forms![Companies]![Sites
subform]![PhysicalZip] & "'")
I have tested the different parts of the expression, and the separate parts
work fine. When I put it all together, I get a Null value returned.
Can anyone tell me what I'm doing wrong?
Thanks.