B Belcredit Jan 17, 2008 #1 How do I tell the querry that my criteria is in the value of a global verable
J John W. Vinson Jan 17, 2008 #2 How do I tell the querry that my criteria is in the value of a global verable Click to expand... You can't, as stated. The JET database engine has no knowledge of VBA constants or variables. You'll need to create a dumb little function, GetVal, like Public Function GetVal() GetVal = glbMyGlobalVariable End Function and use =GetVal() as the criterion in your query. John W. Vinson [MVP]
How do I tell the querry that my criteria is in the value of a global verable Click to expand... You can't, as stated. The JET database engine has no knowledge of VBA constants or variables. You'll need to create a dumb little function, GetVal, like Public Function GetVal() GetVal = glbMyGlobalVariable End Function and use =GetVal() as the criterion in your query. John W. Vinson [MVP]
