Multiple Queries in a Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Queries in a Form

Leo Rivera

4 months ago

Hi I need help from your expert knowledge.

I got a form with a subform appended.
The form is designed looking for a query whish has a filter asking for a year.
Inter the form is a subform that also lookin form a queary that also ask someting.
What I want to do is avoiding the form open the second query.
So for example when I open the form the first query ask me for the year and when I entre for example 2024 inmediately after the next query appear to complete the query question.
What I want to do is to create a vba code that block the second query question and only activate when I click a check box.
Can somebody guide me to what I have to study.

	Adam Schwanz @Reply 4 months ago
The easiest way would be to remove the parameter from the query then control it in VBA. Make your own filter like with Search Form 2.0 even if it's only for one field. Then that second form wont do anything until you give it the input.

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

Next Unseen

New Feature: Comment Live View