How to Fix an Access Form Record Source That References a Deleted Record
Question details
The user needs to resolve a Microsoft Access error in which a form, subform, combo box, or list box still references a deleted table or record.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user opens or edits an Access form and needs to update or remove the obsolete record source reference so the form opens normally.
- Observed behavior
- Access reports that a record source does not exist, and the error can appear before Form_Open or Form_Load runs.
Open the Access database in Design View where possible and display the Navigation Pane and Property Sheet. If a startup form blocks the database, hold Shift while opening the file to bypass automatic startup actions.
Update the invalid record source in the form, subform, combo box, and list box properties
Use this method when you can open the affected form in Design View and need to correct the exact property that still points to the deleted table or record.
Most Access record source errors are caused by one or more properties that still store the name of a deleted table or query. Updating these properties in Design View removes the invalid reference and allows the form to open.
In the Access Navigation Pane, right-click the main form or subform and choose Design View. If Access blocks the database with a startup form, hold Shift while opening the file.
Press F4 or click Design > Property Sheet. In the Property Sheet, select Form from the drop-down, open the Data tab, and inspect the Record Source property.
If the Record Source property shows the deleted table or query, select a valid table or query from the drop-down, or clear the property if you do not need a record source.
Select the subform control on the main form and check its Source Object on the Data tab. Then open the subform in Design View and inspect its Record Source property.
Click each combo box or list box, open the Property Sheet, select the Data tab, and inspect the Row Source or Record Source property. Replace or remove any reference to the deleted table or record.
Press Ctrl+S to save the changes, close the form, and reopen it in Form View to confirm the record source error no longer appears.
Use the Database Documenter and VBA search to find remaining references
Use this method when the error persists or you need to search multiple Access objects for the deleted table or record name.
Switch to WPS Office When Access Form Errors Block Your Work
Microsoft Access record source errors are a Microsoft Office issue, and WPS Office does not modify Access forms. As a free, lightweight Microsoft Office alternative, WPS Office opens and saves the .xlsx, .docx, and .pptx files you already use, with a familiar tabbed interface that makes migration seamless.
- 1. Download WPS Office: Go to the official WPS Office website and download WPS Office for Windows, macOS, Android, or iOS.
- 2. Open your existing Office files: Launch WPS Office and use Writer, Spreadsheets, or Presentation to open your .docx, .xlsx, and .pptx files.
- 3. Work with exported Access data: In Microsoft Access, export the needed tables or queries to Excel or CSV, then open those files in WPS Spreadsheets.
Frequently Asked Questions
Why does my Access form say the record source does not exist after I delete a table?
The form, subform, combo box, or list box still stores the old table or query name in its Record Source or Row Source property. Access tries to open that object and fails before Form_Open or Form_Load runs.
How can I open an Access form in Design View when the record source error appears?
In the Navigation Pane, right-click the form and choose Design View. If a startup form blocks the database, hold Shift while opening the database to bypass automatic startup settings, then open the form.
Where is the Record Source property for a subform?
Open the subform itself in Design View, press F4 to open the Property Sheet, select Form in the drop-down, and check Record Source on the Data tab. Also inspect the main form's subform control Source Object property.
Can WPS Office open or repair Microsoft Access databases?
WPS Office does not include a database engine for .accdb or .mdb files and cannot repair Access form properties. You can export Access data to Excel or CSV and open those files in WPS Spreadsheets.
Will WPS Office open my existing Office files if I switch?
Yes. WPS Office opens and saves .xlsx, .docx, and .pptx files and uses a familiar ribbon interface, making it easy to migrate most Office tasks.
