DLookUp in a Subform

S

SVE

I am trying to reference a field in a subform. Here's the function I used in
the main form and it worked fine, but I can't figure out how to include the
subform reference. My subform is "Contact Types" and the field I'm trying
to reference is "ShippingPostal".

=DLookUp("[City]","Addresses","[PostalCode] = '" &
Forms!Contacts1!PostalCode & "'")

The sooner someone can help, the better as I'm on a deadline for this project.

Thanks for the help.
 
N

Nikos Yannacopoulos

Try:

=DLookUp("[City]","Addresses","[PostalCode] = '" &
Forms!Contacts1![Contact Types]!ShippingPostal & "'")

HTH,
Nikos
 
Top