DLookup not working,HELP!!

[riocobre]

On my form I have the following:



1. A combox (named Combo85) that has a look up to one column in a table (table name is EmployeeInfo); This is working properly
2. I have a textbox (text93). The control source for this box is the expression =[Combo85]; This is working properly, I get the first cell in whichever row step 1 provides.
3. I have another textbook (text95). The control source for this is =Dlookup("[EmpUnit]","EmployeeInfo]","[EmployeeNumber] = ' " & [text93] & " ' ")

When I start the form I get "#Error" in the text95 box.

if I change the Dlook in text95 to =Dlookup("[EmpUnit]","EmployeeInfo]","[EmployeeNumber] = 522426 ") it works properly

Practically all the examples that I see uses numbers.

[riocobre]

Sorry,

I should have check the forum before I posted my question. I saw that it was already answered. Now it is working.

[RuralGuy]

You should really Copy and Paste and code. Typing it again can introduce errors that are not in the original code.
Try this line: =Dlookup("EmpUnit","EmployeeInfo","EmployeeNumber = " & Me.text93 )