Others

How to Update Controls in Access Continuous Forms When Recordset Changes

Nimra MalikNimra Malik Nov 3, 2026 869 views

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.

How to Update Controls in Access Continuous Forms When Recordset Changes
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 you start

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.

Solution 1Recommended

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.

1
Open Design View

Right-click your continuous form in the navigation pane and select 'Design View', then click on the combo box used for filtering.

2
Access the After Update Event

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.

3
Write the Recordset Loop Code

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.

4
Update the Fields and Requery

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.

Use the Combo Box After Update Event to Loop Through the Recordset
Performance Consideration: Looping through large recordsets using VBA can cause performance delays. Ensure your combo box filter restricts the dataset to a manageable number of records before executing the loop.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install WPS Office: Run the installer file and follow the simple on-screen instructions to complete the setup.
  3. 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.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Free and lightweight suite covering Writer, Spreadsheet, Presentation, and PDF workflows.Familiar, tabbed user interface ensuring a seamless migration from Microsoft Office.Built-in data analysis functions and templates to manage records efficiently without complex VBA.
microsoft office alternative - wps office

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.