Need help with Employee ID Dlookup VBA code

[tazui1982]

VarFilter = "[Employee ID]= #" & Forms!DateTimeDLookup!txtEmployeeID & "#"

I'm having trouble with EmployeeID Dlookupfunction. I want Access to show me employee's Last name and First name based on EmployeeID but in the video tutorial that I followed OP used Date of Birth instead, which is why there is "DateTimeDlookup", my EmployeeID field is "ShortText".
What should I have instead of DateTime (infront of Dlookup)


Thanks in advance.

[June7]

If Employee ID is a text type, use apostrophe instead of # as delimiter - # is for date/time type, number type does not require any delimiters.

Your form is named DateTimeDLookup? Use whatever the name of your form is.

Advise no spaces in naming convention. Better would be Employee_ID or EmployeeID.