Others

Fix Access Cannot Find a Record When Leaving a New Form

Ayan Masood Oct 16, 2026 869 views

Question details

The user needs to resolve an issue where navigating away from a blank, new form record triggers a database engine error stating that the record cannot be found.

How to Fix Access Cannot Find a Record When Leaving a New Form

Product: Microsoft Access
Device & OS: not provided
Scenario: Navigating away from a new, incomplete form record after assigning values to bound controls via the Form Current event.
Observed behavior: Access incorrectly treats the blank form as a changed record, attempts to save the incomplete data, and throws a database engine error because the record doesn't fully exist yet.

Before you start

Review your VBA code in the form's Form_Current event to check if you are directly assigning values to bound controls when navigating to a new record.

Solution 1Recommended

Use the DefaultValue Property for New Records

Instead of setting the Value property in the Form_Current event, use the DefaultValue property to initialize fields without marking the record as 'dirty' (changed).

When you assign a value directly to a bound control (e.g., ControlName.Value = 0) during the Form_Current event, Access immediately flags the new record as modified. If the user then closes or navigates away from the form without completing other required fields, Access tries to save the incomplete record, resulting in an error.

By setting the DefaultValue property instead, the form displays the initial value but does not consider the record changed until the user actively edits it.

Open the form in Design View

Right-click your form in the navigation pane and select 'Design View'.

Locate the bound control

Click on the specific field or control (for example, 'Hours_Worked') that requires an initial value.

Set the Default Value in the Property Sheet

Press F4 to open the Property Sheet. Go to the 'Data' tab, find the 'Default Value' property, and enter your desired value (e.g., "0").

Apply DefaultValue via VBA (Optional)

If you prefer to set this dynamically, modify your VBA code to use the DefaultValue property instead of Value. For example: Me.Hours_Worked.DefaultValue = "0".

Use the DefaultValue Property for New Records

Best Practice: Using the DefaultValue property for initializing new records prevents unnecessary database save attempts and keeps your forms error-free.

Solution 2

Implement the Form_Undo Event to Clear Temporary Values

Clear any programmatic changes made to a new record when the user cancels or undoes the record creation.

Free Microsoft Office alternative

Looking for a Reliable Office Suite? Try WPS Office

While Microsoft Access is a specialized database tool, managing exported database reports, data tables, and everyday documentation is easier with a lightweight office suite. WPS Office provides a complete, free alternative to Microsoft Office for all your word processing, spreadsheet, and presentation needs.

Free and lightweight suite for quick installation and smooth performanceEffortlessly manage, filter, and format your exported Access database reports using WPS SpreadsheetHigh compatibility with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Familiar, tabbed user interface for easy migration and multitasking

microsoft office alternative - wps office

Frequently Asked Questions

Why does Access think my blank new record is already changed?

When VBA code (such as in the Form_Current event) assigns data to a bound control's Value property, Access immediately marks the entire record as "dirty" or modified. This forces the database engine to attempt a save when you leave the record, even if it is incomplete.

What is the difference between DefaultValue and Value in Microsoft Access?

The Value property directly modifies the actual data stored in the record, which triggers a save state. The DefaultValue property only provides an initial suggestion in the UI for new records; it does not mark the record as modified until the user manually interacts with it.

How can I safely initialize multiple fields for a new form record?

You can safely initialize multiple fields by setting the DefaultValue property for each respective control. You can do this manually in the form's Property Sheet under the Data tab, or programmatically via VBA by assigning strings, such as Me.ControlName.DefaultValue = "YourValue".

Office Quick Solutions