Others

Filter Microsoft Access Records by Coach and Cycle Radio Buttons

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

Question details

Filter client records on an Access form by the selected coach and cycle.

Filter Access Records by Coach and Cycle Radio Buttons
Product
Microsoft Access
Device & OS
not provided
Scenario
A form uses a coach combo box and cycle radio buttons to select client records stored with Yes/No cycle fields.
Observed behavior
The form should display records for the selected coach whose Yes/No field is true for the selected cycle.
Before you start

Check the names of the client table, coach combo box, option group, and Cycle1 through Cycle4 Yes/No fields in Design View. Confirm that the combo box returns the same CoachID value stored in the client table and that the option group values correspond to the cycle numbers.

Solution 1Recommended

Filter the form with an option-group query

Use this approach when the cycle radio buttons are in one option group and only one cycle can be selected at a time.

The query compares the option group's selected value with the corresponding Yes/No field, while also matching the selected coach. Replace the example table, form, and control names with your own names.

1
Check the option values

Open the form in Design View. Select each radio button and use its Property Sheet to set Option Value to 1, 2, 3, or 4 for the matching cycle. Use an unbound option group and an unbound coach combo box as filter controls.

2
Create the query

Go to Create > Query Design, switch to SQL View, and enter: SELECT * FROM YourTable WHERE CoachID = Forms!YourForm!YourComboBox AND ((Cycle1 = True AND Forms!YourForm!YourOptionGroup = 1) OR (Cycle2 = True AND Forms!YourForm!YourOptionGroup = 2) OR (Cycle3 = True AND Forms!YourForm!YourOptionGroup = 3) OR (Cycle4 = True AND Forms!YourForm!YourOptionGroup = 4)); Save the query after replacing the example names.

3
Set the form record source

In the form's Design View, open the form Property Sheet, select the Data tab, and set Record Source to the saved query.

4
Requery after a selection

In the Property Sheet for the coach combo box, set After Update on the Event tab to [Event Procedure], click the builder button, and add Me.Requery inside the generated procedure. Repeat for the option group's After Update event.

5
Test the filter

Open the form in Form View, select a coach, and choose each cycle in turn. Check that the displayed clients have the selected CoachID and a True value in the corresponding cycle field.

Filter the form with an option-group query
Initial selections: If the coach or cycle control is blank, the query may return no records. Select both values or set suitable default values for the controls.
Free Microsoft Office alternative

Review exported client records in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with exported Office files. Export Access data to Excel to review it in WPS Spreadsheets; WPS does not replace the Access form, query, or radio-button logic.

Review and filter exported client and cycle data in a spreadsheetCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface makes the transition easierFree, lightweight tools for everyday office documents
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the form update when I choose another cycle?

In Design View, check the option group's After Update event on the Property Sheet. Set it to [Event Procedure] and add Me.Requery inside the generated procedure.

Can users select more than one cycle with this query?

No. An option group holds one selected value at a time. For multiple simultaneous selections, use separate controls or a multi-select list box and build a query that reflects the intended matching rules.

What if the query returns no records?

Select both a coach and a cycle in Form View, then check that the combo box returns the stored CoachID and that the selected radio button's Option Value matches its cycle field. Also verify the form and control names in SQL View.

Is there a better way to store cycles than separate Yes/No fields?

For a more flexible design, create a related ClientCycles table with a record for each client-cycle relationship. You can then query related records by cycle instead of adding a new Yes/No column for every cycle.