DlookUp

[BenSteckler]

I am having a Problem with a Dlookup.
The Help says to use this set up

Varx = DLookup("[LastName]", "Employees", "[EmployeeID] = 1")

Where [LastName] is the field to look up, "Employees" is the Table or Query and "[EmployeeID] = 1" is the critieria to meet.

Here is my problem and I can not get it to work. The criteria result is a value assigned to a variable earlier in the Module. I can not So my Criteria would be something like "[EmployeeID] = " VarABC, Where VarABC = 123.

Are there any Ideas? :-(

 

[chrismcbride]

Change

Varx = DLookup("[LastName]", "Employees", "[EmployeeID] = 1")

to

Varx = DLookup("[LastName]", "Employees", "[EmployeeID] = " & VarABC)

That ought to do it
HTH
Chris

 

[BenSteckler]

It worked perfectly.