Query/Subform Glitch

[funderburgh]

I have a subform based on a query where the criteria for the query fields is set to combo boxes on the form. The form works well, but when it is initially opened, the query runs and prompts the user for the criteria data. I need the form to open without the query running so the user can input the criteria data on the form, but I can't determine which property on which object to tweak. I do not have any "On Load" properties established. Any help is welcome.

 

[wazz]

you could use the on load and/or on current events of the subform to set the subform's recordsource to "". after the necessary cboboxes have data, set the subform's recordsource. that's one way.

 

[funderburgh]

Thank you for taking your time to help me. It looks like it working well now.

John