I have a form with a multipage control, and subforms on each control.  I 
wish to open the form, but not to run the queries that populate the 
subforms, unless the user actually clicks on the relevant page.
At this point I would run the query to show the form.

Also the subforms run pass through queries to SQL server database.

I need to send a parameter in this query so that I only return the records 
I need.  Can I do this?  The only thing I can think of is to reset the SQL 
statement each time??  The option, which is my preferred approach, but it 
will not work is to populate the datasheet form using ADO, but I cannot 
get it to advance to the next record on the datasheet.

Any help is much appreciated.