DLookup Headache

[Gregc]

I am using DLookup to fill in a form. If I enter a value in a como box that is not in the list, DLookup returns the same record from the table everytime. If I enter a value that is in the list it returns the correct information from the table. I can't figure out why it won't return a null value for a record that is not in the list. I think that is what it should do.

Here is a copy of one line:

!txtJobName = DLookup("[strJobName]", "tblJobInformation", "'[strJobNumber]='" & "'" & JobNumber & "'")

The JobNumber is text.

I am going nuts trying to figure this out. It was returning the same record everytime until I deleted that record from the table. But that is a question for some other time.

Thanks for the help.
Greg

 

[sbendbuckeye]

Looks like you have too many single quotes in your criteria. Since it is a text value you need single quotes around the test expression only (eg
"[strJobNumber] = '" & YourVariable & "'" which would resolve to
"[strJobNumber] = '1234'"). You do not need them around the variable name used in your test. Its late and I hope I read your code correctly

Hope this helps!

 

[Gregc]

Thanks for the help, that was the problem. I tried every variation but that one.

Thanks agian,

Greg