Two Queries in a Form. - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Two Queries in a Form.

Leo Rivera

2 months ago

Hi you all,

Can you guide me to what course I need to see to do the following: I have a form that have a subform embeded. Both the main form and the subform control source are two diferent queries. Both queries has filter criterias. The main form criteria is a year number and in the subform criteria ask for a month number. However this criteria is not require when the form is open only the main form query is important to be run. However the second query appear. My question is what vba code I need to put for avoiding the second query runs.

	Alex Lewis @Reply 2 months ago
Are you using Parameter Queries? What do your queries do when they run?

Leo Rivera OP @Reply

2 months ago

The main form execute a query for extract all the data that has the date year for example 2026, embedded to the form has an not visible subform that will appear when I clic a check box that execute the second query. And this is work fine, what happen is because the form contain 2 different queries when I open the form Access run the 2 queries criteria. What I want to do is stopped the sencond query until I clic the check box. Is this possible? What is the code that I have to develop in the event of opening the form?

	Richard Rost @Reply 2 months ago
Thanks for your detailed explanation, Leo - I can see you've got a nuanced setup with your form and subform using separate queries, and I appreciate Alex's follow-up questions as well. Since the subform should only run its query when the checkbox is clicked, the ideal approach is to delay setting its RecordSource until then. Or use a button to set it at that time.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View