How to Update Controls in Access Continuous Forms When Recordset Changes
Question details
The user needs a method to dynamically update control properties for individual records in an Access continuous form after filtering with a combo box, since the Form Current event does not process records individually.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Filtering a continuous form using a combo box and attempting to change boolean fields or control formatting for every resulting record in the dataset.
- Observed behavior
- The Form_Current event does not fire for each individual record when the form is rendered, making it impossible to evaluate and update controls on a per-record basis through this event.
Before modifying your VBA events, verify that your combo box is correctly bound to a Row Source and that your continuous form relies on an updateable query or table.
Use the Combo Box After Update Event to Loop Through the Recordset
Since there is no per-record rendering event, trigger a VBA code loop when the combo box value changes to evaluate and update required fields for each filtered record.
By utilizing the combo box's After Update event, you can intercept the user's selection, clone the form's recordset, and programmatically step through every record to apply your logic before refreshing the form.
Right-click your continuous form in the navigation pane and select 'Design View', then click on the combo box used for filtering.
Open the Property Sheet, navigate to the 'Event' tab, locate the 'After Update' property, select '[Event Procedure]', and click the ellipsis (...) to open the VBA editor.
Write VBA code to define a Recordset (e.g., Dim rs As DAO.Recordset), set it to the filtered SQL statement or use Me.RecordsetClone, and use a 'Do While Not rs.EOF' loop to evaluate each record.
Inside the loop, update your boolean fields or logic. Close the loop with 'rs.MoveNext', then apply the new SQL statement to the form's RecordSource and run 'Me.Requery' to display the updated results.

Implement Calculated Fields for Display-Only Controls
If the controls do not need to be edited by the user, use calculated fields in the form's underlying query as a lightweight workaround.
Looking for a Lightweight Office Suite? Try WPS Office
While Microsoft Access is built for complex database management, many of your daily data handling, documentation, and reporting tasks can be managed seamlessly with WPS Office. It provides a robust suite of tools that are fast, intuitive, and highly compatible.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the installer file and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Files Seamlessly: Launch WPS Office and directly open your existing Excel (.xlsx), Word (.docx), or presentation (.pptx) files with zero formatting loss.

Frequently Asked Questions
Why doesn't the Form Current event fire for every record in an Access continuous form?
The Form Current event only triggers when the cursor (focus) moves to a specific record. When a continuous form renders multiple rows on the screen simultaneously, Access evaluates them as a single display operation rather than activating the Current event for each row individually.
Can I use Conditional Formatting instead of VBA in continuous forms?
Yes. For simple visual updates like changing text colors, backgrounds, or enabling/disabling a text box based on its value, Microsoft Access's built-in Conditional Formatting feature handles per-record evaluations natively without requiring VBA loops.
What is the best event to use when filtering a form via a combo box?
The 'After Update' event of the combo box is the most appropriate trigger. It fires immediately after a user makes a selection and moves out of the control, allowing you to execute recordset clones, adjust SQL filters, or requery the form.




