DLookup Help

[Novice1]

I need help with my DLookup code.

I have a form with an unbound combo box (SigBlock) in which the user select sa technician's name (Rowsource: tblTechnicians; bound to TechID). I'm trying to pull a field (Line2), from tblTechnicians, into an e-mail I'm writing. I wrote ...

DLookup("[Line2]", "tblTechnicians", "TechID = Me.SigBlock")

I'm getting a runtime error 2471. The expression you entered as a query parameter produced this error: 'Me.SigBlock'

What am I doing wrong? Thanks

 

[moke123]

your Me.SigBlock needs to be outside the quotes

DLookup("[Line2]", "tblTechnicians", "TechID = " & Me.SigBlock)

 

[Novice1]

That did it ... THANKS!!