Others

How to Fix Access No Current Record Error When Clearing a Form

John Wilson Oct 23, 2026 869 views

Question details

The user needs to resolve a No Current Record error that occurs when clearing an Access form via a requery operation.

How to Fix Access No Current Record Errors When Clearing a Form

Product: Microsoft Access
Device & OS: not provided
Scenario: Running a requery operation on a form that returns no rows, while the underlying VBA form code attempts to reference the current record.
Observed behavior: Microsoft Access displays a No Current Record error and halts execution because the code points to an empty recordset.

Before you start

Before modifying your database's VBA code or deleting records, create a backup copy of your Microsoft Access database file to prevent accidental data loss.

Solution 1Recommended

Handle the No-Records Condition in VBA

Add condition checks to your form's VBA event procedure to verify records exist before referencing them.

When a requery operation returns an empty recordset, any code trying to read or manipulate the current record will crash. By intercepting this state in your VBA code, you can safely redirect the form to a new record instead.

Open the VBA Editor

Open your Microsoft Access database and press ALT + F11 to launch the Visual Basic for Applications editor.

Locate the Event Procedure

Find the form module and navigate to the specific event procedure where the requery operation is triggered.

Add an If Statement

Wrap your record referencing code in an If statement that checks the record count. For example, verify if the recordset contains rows before proceeding.

Implement Navigation Constants

If no records exist, use the appropriate Access commands to move to a blank record by inserting DoCmd.RunCommand acCmdRecordsGoToNew or acCmdRecordsGoToNext.

Syntax Tip: Ensure you are using the correct command constants (acCmdRecordsGoToNew instead of older variations) to prevent secondary IntelliSense parameter errors.

Solution 2

Delete Records Directly from the Underlying Table

Bypass form errors entirely by deleting rows directly from the bound table when clearing all records.

Free Microsoft Office alternative

Need a Lightweight, Free Alternative for Your Office Tasks?

While WPS Office does not include a database management tool like Access, it is the perfect free alternative for all your Microsoft Word, Excel, and PowerPoint needs. Enjoy a lightning-fast, highly compatible office suite without the hefty subscription fees.

1. Download the Installer: Visit the WPS Office website and click the free download button for your operating system.
2. Install the Software: Run the downloaded file and follow the quick installation prompts to set up the suite.
3. Open Your Office Files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint files without losing any formatting.

Fully compatible with Microsoft Office formats like .docx, .xlsx, and .pptxLightweight application that runs smoothly even on older devicesFamiliar user interface requires zero learning curve to masterAll-in-one suite to manage documents, spreadsheets, and presentations

microsoft office alternative - wps office

Frequently Asked Questions

Why does the 'No Current Record' error happen in Microsoft Access?

This error occurs when your database VBA code attempts to retrieve or manipulate data from the current record, but the form is completely empty (usually after a requery or filter that returned zero rows).

What is acCmdRecordsGoToNew used for?

It is an Access VBA command constant used with DoCmd.RunCommand. It instructs the form to safely navigate to a new, blank record for data entry, which is the best way to handle an empty recordset without throwing errors.

Should I delete records using the form or the underlying table?

If you need to clear all records, it is generally safer and more efficient to delete them directly from the underlying table using a SQL query. Deleting via the form's user interface can trigger unwanted form events and navigation errors.

Office Quick Solutions