How to prevent a subforms query from running straight away?

D

Dickie Black

Hi,

I have a main form with a number of subforms. The main form has combo boxes
etc that specify criteria for the subforms' queries. How can I prevent the
subforms queries from being run when the main form is loaded? (When no
values for the criteria will be available) I have a command button which
will then refresh the subforms.

Thanks,

Dickie Black
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Do not run subform criteria when form opens 2
First Subform record gets modified when closing form 3
VBA Syntax for subform record source change 6
Preventing underlying form query from auto refreshing/requerying? 2
Pause Subform 3
Conditional Totals in Subform 0
filtering a form based on the values of a subform 0
Tab control not working with queries 7

Top