Others

How to Create an Access Form to Search and Edit Records

Maira Mehtab Oct 19, 2026 869 views

Question details

The user needs to create a Microsoft Access form that allows searching for specific records by a primary key (like ECN Number) and enables direct editing of the matching records.

How to Create a Microsoft Access Form to Search and Edit Records

Product: Microsoft Access
Device & OS: not provided
Scenario: Building a custom user interface in Access to look up and update database records efficiently.
Observed behavior: The goal is to navigate to a selected record without accidentally modifying or overwriting the primary key during the search process.

Before you start

Ensure your Access form is already bound to the target data table (e.g., Request table) and that your primary key field is clearly defined.

Solution 1Recommended

Use an Unbound Combo Box with the Control Wizard

Using an unbound combo box is the safest method to search for a record without accidentally modifying the underlying data.

By keeping the search combo box completely separate from your bound data fields, you ensure that the primary key remains intact. The unbound combo box acts merely as a navigation tool to trigger the After Update event and load the appropriate record into your editable fields.

Open Form in Design View

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

Enable Control Wizards

Go to the Form Design tab on the ribbon and ensure the 'Use Control Wizards' option is highlighted/turned on.

Add a Combo Box

Select the Combo Box tool from the Controls group and click on the Form Header to place it. This will launch the Combo Box Wizard.

Configure the Search Action

In the wizard, select the option 'Find a record on my form based on the value I selected in my combo box' and click Next.

Select the Primary Key Field

Choose your primary key (e.g., ECN Number) from the Available Fields list, move it to the Selected Fields box, and complete the wizard.

Use an Unbound Combo Box with the Control Wizard

Keep Controls Separate: Ensure you keep this new search combo box separate from the bound ECN Number text box on your form so the primary key remains editable.

Free Microsoft Office alternative

Need a lightweight alternative for data tracking and reporting?

While Microsoft Access is designed for complex relational databases, many everyday data tracking, searching, and reporting tasks can be efficiently managed using robust spreadsheets. WPS Office provides a free, highly compatible suite that handles your data management needs without the steep learning curve of database software.

1. Download WPS Office: Visit the official WPS website and click 'Download WPS Office Free' to get the installer.
2. Install and Launch: Run the downloaded setup file and follow the on-screen prompts to install the suite.
3. Open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet to easily filter, search, and track your data records.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) files for comprehensive data tracking.Free, lightweight, and fast installation compared to heavy database management systems.Familiar user interface makes it easy to transition and start managing records immediately.

microsoft office alternative - wps office

Frequently Asked Questions

Why should I use an unbound combo box instead of a bound one for searching?

An unbound combo box does not save its selection to the current record. If you use a bound combo box for searching, you risk accidentally overwriting the primary key of the currently viewed record instead of navigating to a new one.

How do I generate a report for specific records, like open ECNs, in Access?

You should first create a query that filters your table for records with an 'open' status. Then, go to the Create tab, select Report Wizard, and choose your filtered query as the data source for the report.

Can I apply conditional formatting to my Access reports?

Yes. Open your generated report in Layout View or Design View, select the specific text box control you want to format, and click 'Conditional Formatting' on the Format tab. You can set rules based on values, such as highlighting open records in red.

Office Quick Solutions