I would like to ask your help regarding parameter queries. I badly need this with my project. Please share me a sample database file that uses the parameter query.....
I wanted to learn the querydef method, how to reference a value.
Method below was suggested to me but then i dont have any idea of how to use the querydef.... please help.
Set QD1 = WgtDB.QueryDefs!QFindFormulaDesc
QD1.Parameters![Formula] = gFormula
QD1.Parameters![Plant] = gPlant

I wanted to learn the querydef method, how to reference a value.
Method below was suggested to me but then i dont have any idea of how to use the querydef.... please help.
Set QD1 = WgtDB.QueryDefs!QFindFormulaDesc
QD1.Parameters![Formula] = gFormula
QD1.Parameters![Plant] = gPlant
Last edited: