Hmm, there is a reason why I found I had to use it, but just tried it now and it works without?
Code:
tempvars("tt") = "Paul"
? tempvars("tt")
Paul
From one of my DBs
Code:
TempVars("EmployeeID").Value = Me.cboEmployeeID.Column(0)
TempVars("Employee").Value = Me.cboEmployeeID.Column(1)
TempVars("UserLevel").Value = DLookup("DataOrder", "tblLookup", "LookupID = " & Me.cboEmployeeID.Column(3))
So none the wiser.
I did say you had to use the ! in the query? Access surrounds the criteria with [ & ], if you do not