check box button used with combo box button

[ajohn]

Hello,

This is my first post and I'm kinda new to access.



i have a search form that have a few combo boxes that a user will input values and these values are passed to a query that will show the query results on a subform. I have this one combo box which will only contain 3 values and if the user leaves the combo box blank, all records will show up.

my query parameter looks something like this:

Like "*" & [Form]![Something] & "*"

and the combo box contains 3 values, lets just say "A","B", and "C".

I want to create a check box that if this is unchecked, and the combo box is blank, this will show "A" or "B". If the check box is checked, and the combo box is blank, this will show all records ("A", "B",and "C").

I can't figure out whether to do this in the form design or query parameters.

[Dal Jeanis]

There are several ways to do what you want.

One good way, if there is only one combo box involved, is to have the afterupdate event of the combo box set the filters on the form or subform.

When there are a few different user controls, combo boxes, text boxes, check boxes and so on, I usually create a VBA routine that will build the whole query based on the settings of all the controls, and have each control's afterupdate event call that same routine. That way, I don't have to GUESS about any of the settings.

There's a sample of that VBA in post #8 of this thread - https://www.accessforums.net/queries...orm-36100.html