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!
 
Back
Top