Query based on a parameter query, using VBA how do I set the paramters

[Jim]

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

 

[Sandra Daigle]

Hi Jim,

I'm not sure about ADO but using DAO you would just reference the parameters
of Q1 as though they were actually in Q2. You don't have to do anything
special.