Dlookup function problems

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!
 
A

AlexaLK83

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
DLookup in Forms 5
DLookup returns same name 9
Using A Dlookup Function On A Form When A Combo Box is Updated 2
Trying to use DLookup 3
dlookup #error 2

Top