Dlookup with two criteria syntax help with one being TempVar

[latex88]

Hi, I need help on the condition part of the dlookup function. Both conditions are based on variables, with one created using TempVars in Access 2010.

Variable one: GstrID (a global variable)
Variable two: Created by TempVars.Add "OrderType", strOrderType)

So the function should like something like below...I know I'm nowhere near correct on the syntax

dlookup("MyField", "MyTable", "MyID = GstrID" And "MyOrderType = TempVars(OrderType) )

 

[pbaldy]

This should help:

http://access.mvps.org/access/general/gen0018.htm

Using your variables instead of form references.