Another Post RE: DLOOKUP Runtime Error 2001

  • Thread starter Thread starter Jasonm
  • Start date Start date
J

Jasonm

Hi group -

I am getting a frustrating error in access using the following DLookup
statement:
strWoNum = DLookup("[Department]", "Departments", "[DepartmentID] =
" & Me.DepartmentID)
I am getting the error with or without the criteria... Department contains
string data, Departments is the table name and DepartmentID contains a Long
Integer. Me.DepartmentID has returned a value and that value SHOULD
corospond to a value in the table.

I haven't seemed to have any luck with tracking down the cause of this
error! I have tried several variants of bracketing and quotes, but no luck!

Please help...

Jasonm
 
Back
Top