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

Linq Adams via AccessMonster.com

However, if I pause before typing 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

I, too wasn't aware that Access had a time limit for entering data! This type
of code should be in the AfterUpdate event for the ID # textbox. If you've
made the mistake, as many people do, of placing it in the incorrect event,
such as the texbox OnChange event, it might account for part of this problem.

You really need to post the code you're using, as you should anytime you're
asking people to help you figure out why it's not working. Remember, you have
your database in front of you, but we can't see it!
 
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!
 
Top