Others

Troubleshoot a Microsoft Access Continuous Form That Keeps Reloading

Jason MillerJason Miller Nov 22, 2026 868 views

Question details

Identify why a continuous form repeatedly reloads the same records.

Product
Microsoft Access 2016 with a SQL Server back end
Device & OS
not provided
Scenario
A user is viewing records in an Access continuous form connected to SQL Server.
Observed behavior
The form intermittently reloads the same records in a loop.
Before you start

Open the affected form in Design View and identify its Record Source and event procedures. Note when the loop occurs and whether it affects other forms connected to the same SQL Server tables.

Solution 1Recommended

Find Repeated Form Events and Requery Commands

Use this approach to identify Access event procedures or timers that repeatedly reload the form.

1
Inspect the Record Source

Open the form in Design View, select the form, and open Property Sheet > Data. Review Record Source for queries or expressions that could cause repeated data retrieval.

2
Review form events

In Property Sheet > Event, check On Load, On Current, On Timer, and other relevant events. Open each event procedure or macro and look for Requery, Refresh, or code that triggers another event.

3
Check timer and control behavior

Review Timer Interval in the form's Event properties and inspect control sources and control event procedures. Temporarily disable suspect timer or event logic in a test environment to see whether the loop stops.

4
Trace the event sequence

Open the VBA editor, set breakpoints in suspect event procedures, or add Debug.Print statements. Reproduce the issue and use the Immediate window to identify which events and commands repeat.

5
Remove the circular trigger

Edit the identified procedure or macro so that a requery does not repeatedly trigger the same event chain. Reopen the form and test record navigation and updates.

Find Repeated Form Events and Requery Commands
Requery and refresh are different: Requery runs the underlying query again; Refresh updates current records without necessarily rerunning the query. Check both when tracing event logic.
Free Microsoft Office alternative

Use WPS Office for Everyday Document and Spreadsheet Work

WPS Office is a free, lightweight alternative for everyday office work. Its familiar interface and Microsoft Office format compatibility make it easy to move documents and spreadsheets, although it does not troubleshoot or replace an Access database.

Work with spreadsheet data in WPS Spreadsheets.Open and edit Microsoft Office formats including DOCX, XLSX, and PPTX.Use a familiar interface for common office tasks.Move existing documents and spreadsheets into a lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Can a form timer cause repeated reloads?

Yes. In Design View, check Property Sheet > Event for Timer Interval and On Timer. An On Timer procedure that calls Requery or triggers another event may repeatedly reload data.

How can I tell whether an Access event is looping?

Open the VBA editor and set breakpoints or add Debug.Print statements to relevant form events, such as On Current and On Load. Reproduce the issue and inspect the sequence in the Immediate window.

What is the difference between Requery and Refresh?

Requery runs the underlying query again, while Refresh updates current records without necessarily rerunning it. Review both commands in event procedures when investigating repeated activity.

How do I check whether SQL Server is contributing to the problem?

Capture activity with SQL Server Profiler or Extended Events and compare repeated queries with the Access event log. In SQL Server Management Studio, also check for blocking and slow query execution.

Can WPS Office fix an Access form requery loop?

No. The form and SQL Server connection must be investigated in Access and SQL Server. WPS Office can be used separately for compatible documents and spreadsheets.