DLookUp


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.
 
Ad

Advertisements

J

JMD.Park

Maybe I need to use RecordSet? Is there a specific class I can take that will
improve my knowledge in this area?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 DLOOKUP 26
DLOOKUP 2
Dlookup and Conditional Formatting 3
Dlookup issue with Access 2003! PLEASE HELP!!! 1
Dlookup 7
Fill blank fields with value from field above it 3
dlookup 2
Dlookup error 4

Top