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

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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.
 
Back
Top