Dlookup

A

Anthony

Has anyone ever had trouble with DLookUp *not* returning the correct value,
or returning a NULL value, when in fact there is for certain data in the
field you are quering with DLookUp?
 
A

Allen Browne

DLookup() wrongly returns Null if the value is a zero-length string.

It that's not the case, you are probably not forming the 3rd argument
correctly. Bracketing and delimiters are important. Basic info on:
http://allenbrowne.com/casu-07.html

If that's not helpful, post the expression you are using.
 
S

Steve Schapel

Anthony,

Yes, I have experienced that problem. I fixed it by correcting the
error I had made in writing the DLookup expression. What is the exact
expression that is giving you grief, and where/how are you using it?
 

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

Update Combo Box 4
nz with dlookup 1
DLookup with dates 1
DLookup or Code 2
is there a Dlookup to get entire record or multiple fields ?? 8
Convert DLOOKUP text to Long Time format 0
Dlookup in table won't work 2
Dlookup on Continuous Sub 4

Top