Missing Operator

[Matthew Snook]

I have the following code:

VarEntity = DLookup("[Entity_ID]", "PITTagEvent", "PITTag_Code = " & InString)

Where:
VarEntity is a variant variable;
Entity_ID is the field I would like returned;
PITTagEvent is the table to be searched;
PITTag_Code is the field to be searched, and;
InString is a variable containg the search expression;
"3D9.1bf114a1a5" is the text currently in the variable InString.

I get this!:
Syntax Error (missing operator) in query expression 'PITTag_Code = 3D9.1bf114a1a5'.

I have tried to copy letter by letter from the help files, I've checked my spelling. I've even taken out the variables and used actual values. Same results returned. What else can cause this error?

Thanks,

Matt

 

[Matthew Snook]

Thanks Pat!

It works perfectly, of course. I commented my version out, pasted yours in, and off it went!

Matt