Hi, through Access 2003 VBA, I'd like to run a second query using the query results from a previous first query.
The user would click a cmd button on a userform to perform this task automatically.
Is there a simple way to run these 2 queries like this?
p.s. I already have the second query executing via a userform cmd button _Click() event in VBA......I'd like to know, in general terms, how to run the second using only the results of the first (source data table and field requirements are the same for both queries)
Thanks
The user would click a cmd button on a userform to perform this task automatically.
Is there a simple way to run these 2 queries like this?
p.s. I already have the second query executing via a userform cmd button _Click() event in VBA......I'd like to know, in general terms, how to run the second using only the results of the first (source data table and field requirements are the same for both queries)
Thanks