To create a split form in Microsoft Access for Windows, select a table or query in the Navigation Pane, then choose Create > More Forms > Split Form. Access opens a form with a form view and a datasheet view of the same records; save it with Ctrl+S, then adjust its layout and fields as needed.
What a split form does
A split form combines two ways of working with the same data on one screen. One section displays a single record in a familiar form layout, with fields arranged for reading or editing. The other displays multiple records in rows and columns, much like a table datasheet. Selecting a row in the datasheet changes the record shown in the form section, and moving to another record in the form section updates the selected row.
This arrangement is useful when someone needs both an overview and a clear view of the details. For example, a small service team could use a split form based on a Customers table: staff can scan customer names in the datasheet and see the selected customer’s phone number, email, and notes in labeled controls. It avoids opening a separate record form and switching back to a table just to find another entry.
A split form is still a form bound to a record source, not a second copy of the data. Whether users can edit, add, or delete records depends on the form’s source and its settings. A table or an updateable query usually supports editing; a query that combines or summarizes data in a way Access cannot update may not.
Create the form from a table or query
- Open the database in the Access desktop application and locate the table or query you want in the Navigation Pane. Choose a source that contains the fields users need to view or edit.
- Select the source object once. You do not need to open it first.
- On the ribbon, choose Create > More Forms > Split Form. Access creates the form and opens it, commonly in Layout View, where you can see the data while making layout changes.
- Review both sections. Confirm that the datasheet shows useful columns and that the form section displays the important fields in a sensible order.
- Press Ctrl+S, enter a descriptive form name, and select OK. Names such as
frmCustomersSplitare easier to distinguish from tables and queries than a generic name.
If you do not see the command, make sure you are using the Windows desktop version of Access and that the ribbon’s Create tab is visible. Access for the web is not a full substitute for designing desktop Access forms, and Microsoft does not provide a native Access desktop application for macOS. On a Mac, opening and designing an Access database generally requires access to Windows, such as through an appropriate virtual machine or remote Windows computer.
Choose a useful record source
The record source determines what data the split form can display. Starting from a table is straightforward when the form represents one kind of record, such as products or appointments. A query is helpful when users should see a filtered or carefully selected set of fields—for instance, only active projects, or orders placed after a chosen date. Build and check the query before creating the form so you know which records and columns it returns.
Think about the task, not just the available fields. A customer-service form might need customer name, contact details, and a short account status. Showing every internal field in the datasheet can make it crowded and expose information that is irrelevant to routine work. Conversely, a staff member who must identify the right record quickly may need a unique number or another distinguishing field in the datasheet, even if that field is not prominent in the form section.
Access forms are often based on tables designed with relationships, rather than one oversized table containing repeated details. If a form needs to show related records—such as a customer’s orders—a subform may be a better choice for those related rows. A split form focuses on two synchronized views of one record source; it does not automatically create a separate related-record area.
Arrange fields and the split
After Access generates the form, inspect it in Layout View or Design View. Layout View lets you rearrange controls while the form displays real data. Design View offers more precise control over form structure and properties. Use the form’s controls and ribbon tools to resize text boxes, move labels, and remove fields that do not help users complete the task. Save after meaningful changes.
The dividing bar between the form and datasheet sections can be dragged while the form is open to give more space to the section that matters. A wide form area helps with long notes or many labeled fields; a larger datasheet area makes it easier to scan more rows. The available orientation and detailed split behavior can be adjusted through the form’s properties in Design View. Select the form itself—not an individual text box—before changing form-level properties in the Property Sheet. If the selected object is wrong, the Property Sheet will show properties for that control instead.
Make the datasheet readable as well as the form. Reorder or resize columns, use meaningful captions, and avoid relying on a cryptic field name such as CustID when users need a recognizable label. Keep a primary key available when it helps distinguish records, but consider whether users should see it. A stable unique identifier can prevent confusion between people with similar names.
Use and edit records safely
In Form View, users can select a record in the datasheet and work with its fields in the form section. They can also navigate between records using the form’s navigation controls. When a user edits a field, Access generally commits the change when the user moves to another record or otherwise leaves the record; the precise timing can depend on the action and validation rules. The datasheet and form are two views of the same underlying record, not independent editing areas.
Before distributing the form, decide what users are allowed to do. A form’s properties can control whether records can be edited, added, or deleted, and individual controls can have their own locked or enabled settings. If the form is intended only for looking up information, restrict editing deliberately rather than assuming the layout itself prevents changes. If users should enter new records, test how they reach a new-record row and whether required fields and validation rules behave as expected.
Use realistic test records, including blank optional fields, long text, and similar names. Check that edits appear in the underlying table or query as intended. If the database contains sensitive data or multiple people will use it, plan permissions and database deployment separately; a split form is a user interface, not a security boundary.
Split form, datasheet, or continuous form?
A datasheet is compact and familiar for scanning many fields, but it can be harder to interpret when field names are unclear or records contain long values. A single form gives each record more space and supports a tailored layout, but users may have to move through records one at a time. A split form combines the strengths of both when users routinely browse a list and inspect one selected record.
A continuous form is another option: it repeats a designed form layout for multiple records, often showing selected fields in each row. It can offer more control over how each row looks than a datasheet, but it does not provide the same paired form-and-datasheet arrangement. A subform is different again: it embeds a related form, often showing child records connected to the current parent record. Choose a split form for two views of the same source; choose a subform when the user needs to see related records.
Common problems and practical fixes
- The form opens but records cannot be edited: Check whether the record source is updateable and whether the form’s editing properties or control settings prevent changes. A query’s joins, totals, or other design choices can make its results read-only.
- The datasheet shows too many columns: Remove unnecessary fields from the form’s source or adjust the datasheet layout. Keep the fields that help users identify and compare records.
- The selected row and form details seem mismatched: Confirm that both sections belong to the same split form and that you are viewing the expected record. Also check whether a filter or sort order is hiding records or changing their displayed order.
- The form is difficult to read: Increase the space for the form section, widen controls for longer values, and use clearer labels. Check the form at the screen size people will actually use.
- Changes do not appear in the table: Check for validation errors, required fields, and whether the record has been committed. Confirm that the form is bound to the intended table or query rather than an unrelated source.
Do not treat a split form as a shortcut around data design. If the same customer information is stored repeatedly in several records, improving table relationships may prevent inconsistent updates more effectively than changing the form layout.
Frequently Asked Questions
Can a split form show a table and a form at the same time?
Yes. It shows a datasheet and a form view of records from the same record source. Selecting a record in one section synchronizes the current record in the other.
Can I create a split form from a query?
Yes. Select the query in the Navigation Pane and use Create > More Forms > Split Form. The query must return the fields the form needs, and whether its results are editable depends on whether the query is updateable.
How do I make the form section larger?
Open the form and drag the divider between the form and datasheet sections. You can also review the form’s split-related properties in Design View if you need to change its layout behavior.
Can I change which fields appear in the datasheet?
Yes. Adjust the fields included in the form’s source or modify the datasheet layout, then save the form. Test the result in Form View so the visible columns support the user’s task.
Is a split form the same as a subform?
No. A split form presents two views of one record source. A subform is embedded in another form to display related records, such as a customer’s orders within a customer form.
Before sharing the form
Try the finished form as a user would: locate a record, inspect its details, change a permitted value, and check how a new record is added if that is part of the workflow. Confirm that sorting, filtering, labels, and column widths make sense, and that the source does not expose unnecessary fields. A well-chosen record source and a restrained layout make a split form useful; adding every available field usually makes it harder to use.
Related
- SQL Split Command: How to Split Text Across Databases
- String Length in C++: size(), length(), and Examples
- Reverse a String in C++: std::reverse and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Row Stays When Scrolling? Keep It VisibleTo make an Excel row stay visible while you scroll, freeze it: in Excel for Microsoft 365 on…
- Active Print Area in Excel: Meaning and SetupIn Excel, the “active print area” usually means the cell range currently designated to print on a worksheet;…
- Household Budget Spreadsheet: Build One in ExcelA household budget spreadsheet is a simple way to compare monthly income with planned and actual expenses. In…
- Excel: Add Superscript to the Ribbon Button and Use ItYes. In Excel for Microsoft 365 on Windows, you can add the Superscript command to a custom group…
- Vertex Debt Snowball Spreadsheet: How to Use ItIf by “Vertex” you mean Vertex42, the relevant resource is its Debt Reduction Calculator spreadsheet; check Vertex42’s official…
- Excel Solver for Beginners: Set Up Your First ModelExcel Solver finds values for selected cells that maximize, minimize, or reach a target in a formula, while…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.