Subform problem

[quasimodo]

I'm having problems with a subform.

I have a parameter query (used to search). How can i get the results to be displayed in a subform, rather than in a new window?

I've tried putting the control source of the subform as the query, but this runs the query staright away when the main form is opened. Is there a way to have the results in the subform, but for the query to run only when a command button is clicked?

I would really appreciate any help....

 

[jeremie_ingram]

One suggestion would be to base the subform off of a seperate table, then change the parameter query to either an update or append query (which ever best suits the situation) and have it dump the data into the table via the comand button. If you want the subform to show nothing on open, then I would put a delete query in the On Open function of the form and in the begining of the comand button code to go and delete existing files from the table.