Access ACCESS DLOOKUP INVALID USE OF NULL

C

cuddihy1990

Joined
Feb 26, 2013
Messages
12
Reaction score
0
Hey guys I have 3 DLookups to return values in access vba from 2 different tables;
Below is the code that I am using;

EmpName = DLookup("[Name]", "dbo_BomEmployee", "Employee =" & BUILDID)

OvenName = DLookup("[Name]", "dbo_BomEmployee", "Employee =" & OVENID)

NewStatus = DLookup("[Status]", "Employees_Performance", "LotNumber =" & LOTNUMBER)
Click to expand...

The top 2 DLookups work fine but the bottom one throws an 'Invalid use of Null' error message. I have checked the Employees_Performance table and LOTNUMBER (lets say for arguments sake is 290856-2 is in there under the LotNumber column.

Any ideas as to where I am going wrong.

Thanks for any replies in advance.
 

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

Quick and probably quite simple Invalid Use of Null Aftermath Ques 2
Dlookup invalid use of null 6
DLookUp Invalid Use of NUll 8
DLookup Invalid Use of Null 1
Invalid use of Null 15
Invalid use of null value error Access 2007 0
Help with Invalid Use of NULL and Dsum function 3
Invalid use of Null Error 2

Top