dynamically create pass-through-query

J

Jason

Hi,

I've the following problem with access 2000.

I get recordsets through an ado-connection for every form i create.
However for reports recordsets cannot be set (it is possible in access
2002 and 2003).

So what i would like to do, this:

- when a user clicks on a button
- create a pass-through-query and set appropiate property settings
- get data for the reports recordsource

How can i do this, i think through dao, but i don't know how. Any
examples would be appriciated.
 
Top