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

After my head exploded from adapting to Access from Excel, I found that I had multiple personalities that posted the solutions on the same websites that I'd asked the question on.

I'm off to China.

I wish I'd realised I had an extra "'" at the start of one of the variables before, I've wasted my opportunity to finish this project.

Thanks Mr. Tur, I had adapted another of your posts to solve this one.

-Andy.