A Microsoft Access split form shows the same records in two connected views: a form for working with one record at a time and a datasheet for seeing multiple records in rows and columns. To create one in Access for Microsoft 365 on Windows, select a table or query in the Navigation Pane, then choose Create > More Forms > Split Form.
What an Access split form is
A split form combines Form view and Datasheet view in a single Access form. One part displays fields for the current record in a familiar form layout; the other displays records in a grid. The two parts are synchronized: select a row in the datasheet and the form displays that record, or move to another record in the form and the datasheet selection follows.
The split form is one object connected to one record source, not two separate forms placed side by side. Both panes work with the same underlying set of records. This makes the design useful when a person needs both a broad view of a list and a convenient way to inspect or edit the details of a selected item.
For example, an inventory split form could show product names and stock quantities in the datasheet pane and display the selected product’s description, supplier, and reorder information in the form pane. The grid helps locate a product; the form gives more room for fields that would be awkward to read in narrow columns.
How the two panes work together
The datasheet pane presents records as rows and fields as columns. It supports familiar table-like actions such as selecting a record, scrolling through rows, and changing column widths. The form pane presents the current record using the form’s controls and layout. Depending on the form’s settings and whether its record source allows edits, a user may be able to change field values in either pane.
Because the panes share a record source, moving between records in one pane changes the current record shown in the other. Filtering or sorting the records can also affect what is available in the form, depending on the action and the form’s settings. A split form does not create a second copy of the data, and editing a record changes the underlying record rather than a separate display-only version.
That shared source is important. A split form based on an updateable table or query can generally support editing, subject to the form’s permissions and properties. A query that joins tables, aggregates values, or otherwise is not updateable may limit or prevent changes. If editing does not work, inspect the record source as well as the form controls.
Create a split form
- Open the database in the Access desktop application and locate the table or query that should supply the records.
- Select that object in the Navigation Pane. You do not need to open it first.
- On the ribbon, choose Create > More Forms > Split Form.
- Access creates a form based on the selected object. Review the layout and confirm that the fields and records are appropriate for the task.
- Save the form with a descriptive name, such as Product Review or Customer Lookup.
Starting from a table is straightforward when the form needs to work directly with that table. Starting from a query is useful when the form should show only certain fields or records. Before relying on a query-based split form for data entry, verify that the query returns the records you expect and permits updates. Access may create a form successfully even when the chosen query is not suitable for editing.
Choose the layout and adjust the form
A split form’s orientation determines where the datasheet appears relative to the form pane. Depending on the design, the datasheet can be above, below, to the left, or to the right of the form. A vertical arrangement often suits records with many fields, while a horizontal arrangement can work well when the datasheet needs more width for several identifying columns.
To change the design, open the form in Layout View or Design View. Press F4 to show the Property Sheet if it is hidden, and select the form itself in the property selector. On the All tab, review properties such as Default View and Split Form Orientation. Property names and available choices can depend on the form and Access version; use the property’s dropdown when one is provided.
In Layout View, you can arrange and resize controls while seeing sample data. Design View gives more detailed control over the form’s structure and properties. You can also adjust the relative space available to each pane by dragging the splitter bar when it is enabled. Try the layout with realistic data: a field that looks short with a sample value may need more room when it contains a full address or longer description.
Keep the two panes purposeful. The datasheet is usually most useful for a few identifying fields, such as a name, date, status, or category. Put longer or less frequently scanned information in the form pane. If the grid contains too many columns, users may have to scroll sideways and lose the quick overview that makes the split form valuable.
When a split form is a good choice
Use a split form when users need to browse a set of records and inspect one record’s details without opening a separate screen. It can suit small internal databases for inventory, contacts, service requests, orders, or similar record-based work. It is especially helpful when people recognize a record from a few columns but need more information before making a change.
- Finding and reviewing records: Scan a list of service requests, then inspect the selected request’s notes and contact information.
- Routine updates: Locate a product in the grid and change its description or status in the form pane.
- Data checking: Compare a short list of key fields while reviewing the complete record in the form.
A split form is not automatically the best interface for every database. If users should only view information, a report or read-only form may be safer. If the task involves a sequence of steps, complex navigation, or many related records, a purpose-built form with buttons, subforms, or a navigation structure may be clearer.
Editing, adding, and deleting records
Whether users can edit data depends on more than the split layout. The form’s Allow Edits, Allow Additions, and Allow Deletions properties, the record source, field settings, and database permissions can all affect what is possible. A read-only query or a locked form may let users browse records without changing them. Conversely, an editable form can expose changes through either pane.
New-record entry is governed by the form’s record source and settings. If additions are allowed, users can typically move to the new-record row in the datasheet or use the form’s record navigation controls. Deletion should be considered carefully: deleting a row from an editable datasheet can delete the underlying record, not merely hide it from view. The database’s relationships and referential integrity rules may prevent deletion or affect related data.
For a shared database, decide deliberately which users should be able to add, edit, or delete records. Test the form with an appropriate non-production copy or sample data before giving it to users. A split form changes how data is presented; it does not by itself provide a complete security system or a backup.
Common problems and practical fixes
- The datasheet or form pane is missing: Check that the form’s Default View is set to Split Form and review its split-form properties. Reopen the form after saving design changes.
- The panes have the wrong arrangement: Open the Property Sheet, select the form, and check Split Form Orientation. Use the available choices rather than assuming the pane arrangement follows the screen size.
- Changes cannot be made: Check whether the form allows edits and whether the record source is updateable. Also check whether the relevant control is locked or disabled and whether the database permits the change.
- Records appear in an unexpected order: Look for sorting or filtering applied to the form or datasheet. Clear or revise it, then confirm that the record source itself is not imposing a different order.
- Some columns are hard to read: Widen the datasheet columns or remove fields that are not needed for scanning. Put long text and less commonly used fields in the form pane instead.
- The form appears crowded: Consider changing the orientation, resizing the panes, or simplifying the controls. Check the result at the size users will actually have on screen.
When troubleshooting, distinguish a display issue from a data issue. A field that is absent from the form may simply not have been included in its design, while a record that is absent from both panes may be excluded by a filter or query. Make one change at a time and check the form again so it is clear which setting resolved the problem.
Split form compared with other Access forms
A standard single-record form focuses on one record at a time and can provide a clean, spacious layout, but users may need navigation controls to find the next record. A continuous form displays multiple records using a repeated form layout, which can offer more design flexibility than a datasheet but may take more work to build. A datasheet is compact and familiar for tabular work, though it can be difficult to use for long text or a large number of fields.
A split form combines the quick scanning of a datasheet with the detailed presentation of a form. The trade-off is that both views share one record source and take space in the same window. Choose it when the two synchronized views help the task; choose another form style when users need a more guided workflow, a specialized layout, or a simpler read-only display.
Access availability and platform notes
Microsoft Access is a Windows desktop application; Microsoft does not provide a full Access desktop application for macOS. The ribbon path in this article applies to Access for Microsoft 365 on Windows. If you are using another Access release, the ribbon organization or wording may differ, but the key idea remains a form that combines form and datasheet views. Access databases can be used in different deployment arrangements, so confirm that the form is being opened in a compatible Access desktop environment.
Frequently Asked Questions
What does a split form do in Microsoft Access?
A split form displays one record in a form layout and multiple records in a datasheet at the same time. Selecting a record in either pane synchronizes the current record shown in the other.
How do I create a split form in Access?
Select a table or query in the Navigation Pane, then choose Create > More Forms > Split Form. Review the generated form and save it with a useful name.
Can I edit records in both parts of a split form?
Often, but not always. Editing depends on the form’s settings, the updateability of its table or query, and database permissions. A split layout alone does not guarantee that records can be changed.
Can I change which side the datasheet appears on?
Yes. Open the form in Layout View or Design View, show the Property Sheet with F4, select the form, and review Split Form Orientation on the All tab.
Is a split form the same as a subform?
No. A split form shows two synchronized views of the same form record source. A subform is a separate form embedded in another form, commonly used to show related records such as an order’s line items.
Why can’t I edit a record in my split form?
The form may disallow edits, a control may be locked, or the table or query may not support updates. Check those settings and confirm that you are working with the intended record source.
Related
- Balance of Payments Notes: Accounts, Examples and Meaning
- Java split(): How It Handles Delimiters and Limits
- Java String split(): Syntax, Regex, 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
- How to Add a Morph Transition in PowerPoint SlidesTo add a Morph transition in PowerPoint, duplicate a slide, change the position or size of an object…
- How to Set Up Automatic Email Forwarding in OutlookTo automatically forward every new message in Outlook, open Settings, go to Mail > Forwarding, turn on forwarding,…
- Print an Excel Spreadsheet: Setup, Pages, and TipsYes, you can print an Excel spreadsheet from Microsoft Excel for Microsoft 365 on Windows: open the workbook,…
- Excel Remove Duplicates While Keeping the Oldest DateTo remove duplicate records in Excel while keeping the oldest date for each item, sort the entire table…
- How to Insert a Line Through a Word in ExcelTo put a line through just one word in an Excel cell, edit the cell, select the word’s…
- Excel Day School? Meaning and How to Identify One“Excel day school” does not identify one universally recognized school: it may refer to a particular school named…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.