Dlookup function problems

  • Thread starter Thread starter AlexaLK83
  • Start date Start date
A

AlexaLK83

I am making a simple Access database for work and have a couple of issues:
1) In my form I have a dlookup funtion. When I enter the Client ID #, the
Client Name will automatically populate. However, if I pause before typing
the ID # or if I type the wrong number and backspace to correct it, it will
not pull in the client name?? This makes no sense to me, please help!
 
The code is: =DLookUp("[Client Name]","[Clients]","[Client #]=[Forms]![QA
Audit Checklist]![Client #]")

I have it as the Client Name Control Source. I hope this helps and more
info is needed please let me know. I am very new at all of this.

Thanks!
 

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

DLOOKUP CONFUSION 3
dlookup challanges 1
DLookUp Format 4
Trying to use DLookup 3
DLookup - why this syntax? 12
dlookup #error 2
DLookup 4
dlookup function only check first record in a table 2

Back
Top