J
JMD.Park
Lets try this again. I am trying to use DLookup to bring up several fields
from a table into a form. Can someone please let me know if this is possible
and tell me how to do this? I am new to expression builder so please be
patient with me and specific as well as where to build.
I would like this "CustomerName" that is a number field in Form called
"Distribution" to bring up these fields from "Historical" table that is
linked by the way. The following fields are for me to verify that I have the
correct customer
number. The fields are all text and are fields of there own in the form.
They are as follows: BusinessName ,MailingAddress1, Mailing
Address2, MailingCity, MailingState, MailingZip, and Phone. I tried this:
=DLookUp("[Distribution]","Historical","[CustomerNumber] = "
&Me.[CustomerNumber])
I receive an error. I have also tried the wand. It does not bring up the
correct customer with number and only brings up several fields that are not
placed in the forms table.
from a table into a form. Can someone please let me know if this is possible
and tell me how to do this? I am new to expression builder so please be
patient with me and specific as well as where to build.
I would like this "CustomerName" that is a number field in Form called
"Distribution" to bring up these fields from "Historical" table that is
linked by the way. The following fields are for me to verify that I have the
correct customer
number. The fields are all text and are fields of there own in the form.
They are as follows: BusinessName ,MailingAddress1, Mailing
Address2, MailingCity, MailingState, MailingZip, and Phone. I tried this:
=DLookUp("[Distribution]","Historical","[CustomerNumber] = "
&Me.[CustomerNumber])
I receive an error. I have also tried the wand. It does not bring up the
correct customer with number and only brings up several fields that are not
placed in the forms table.