Is that you Steve?

try here:

http://www.vbaexpress.com/forum/showthread.php?t=22298

[vba]
stg2 = DLookup("DOORCODE", "DoorDesign", "DOORDESCRIPTION= '" & Me.door_type & "'")
[/vba]

-AS