Query based on a parameter query, Using VBA how to assign the parameters

Query based on a parameter query, Using VBA how to assign the parameters

Post by Jim » Tue, 13 Jan 2004 02:45:11


ADO coding in MS-Access 2002

I have a query (Q2) based on a parameter query (Q1) and need to set the
parameters within a VBA module. I am using ADO, and opening the query (Q2)
as a fordwardonly recordset.

Since Q1 isn't explictly opened in the VBA code, I'm not sure how to set
the parameters.

I do not want to run Q1 to load a table and then have Q2 based on the table
if I can avoid it. Nor do I want to place the parameters in a table and
have Q1 reference them there.

Any suggestions ?

Thanks