Dlookup

[Wombat]

I want to fill a textbox with the hiredate of an employee

Dim Hdate As Date
Hdate = DLookup("[HireDate]", "Employee", "Employee.EmployeeID = " & Forms!frm_EmployeeInformation.EmployeeID)

Gives me the error:
Run-time error '3075':
Syntax error (missing operator) in query expression
Employee.EmployeeID = 55BBBBBBBB

that 55BBBBBBBB is the sample employee number that I put in there, so I don't understand why it's not working.



The field is set to text but the error changes if it is all numbers or all letters.

[irish634]

Hdate = DLookup("[HireDate]", "Employee", "Employee.EmployeeID= " & Forms!frm_EmployeeInformation.EmployeeID)

Take the space out after employee id.

[Wombat]

That wasn't it, but I figured it out.

if you use a text criteria in your dlookup "where" clause you must put the text value in single quotes:
Hdate = DLookup("[HireDate]", "Employee", "Employee.EmployeeID = '" & Forms!frm_EmployeeInformation.EmployeeID & "'")