Dlookup,

Why is it that I can get a result from:

[vba]
stg2 = DLookup("DOORCODE", "DoorDesign", "DOORDESCRIPTION='Two Central Window Single'")
msgbox(stg2)
[/vba]

but not from:

[vba]
stg1 = "Two Central Window Single"
MsgBox (stg1)
stg2 = DLookup("DOORCODE", "DoorDesign", "DOORDESCRIPTION=" & stg1)
[/vba]

I don't understand how it is different!!!!!

Can someone please help with Dlookup

Thanks,

-Andy.