When does the query run after all the criteria has been selected? I don't see a button to run the query.
What is the source object for your subform control (i.e. what is the control linked to)?
AFAIK, the simplest is to link the subform control to your query - that is where it will show when it opens, which might be as soon as your form opens. That depends on what code you have written to control this. If that is the case and you don't like the result, set the subform control object.source with a button click. Try
Code:
Forms!yourFormName!Controls.SubformControlName.SourceObject = "Query.yourQueryName"
Last edited by Micron; 04-28-2016 at 08:32 AM.
Reason: dreaded automated 50 character space
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.