DLookUp in a Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try:

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

HTH,
Nikos
 
Back
Top