To create a form in Access, select a table or query in the Navigation Pane, open the Create tab and click Form. Access builds a form showing one record at a time, with a control for every field, and opens it in Layout view ready to adjust. Press Ctrl+S to save it.
That one-click form is often enough. The other tools in the Forms group of the Create tab give you more control over what goes on the form and how it is laid out. The steps here match Access in Microsoft 365 and recent perpetual versions; Access is a Windows desktop application and has no web or Mac version.
Start with a table
A form is a window onto a table or query, called its record source. If you want to follow along, create a table in a blank database: on the Create tab click Query Design, close the Add Tables pane, switch to SQL View, paste this statement and click Run.
CREATE TABLE Customers (
CustomerID AUTOINCREMENT PRIMARY KEY,
CustomerName TEXT(100) NOT NULL,
Email TEXT(255),
City TEXT(60),
JoinedOn DATETIME
);
Customers now appears in the Navigation Pane.
Which form tool to use
| Tool (Create tab, Forms group) | What you get | Use it when |
|---|---|---|
| Form | Single-record form with every field | You want a working form immediately |
| Form Design | Empty form in Design view | You want full control over placement |
| Blank Form | Empty form in Layout view with the Field List open | You want only a few fields |
| Form Wizard | A guided set of questions | You want to pick fields from several related tables |
| Navigation | A form with tabs that load other forms and reports | You need a menu for the application |
| More Forms > Multiple Items | Several records per screen, one per row | You want a customisable list |
| More Forms > Datasheet | A spreadsheet-style grid | You want fast bulk viewing and entry |
| More Forms > Split Form | A single-record form and a datasheet together | You want to browse in the grid and edit in the form |
| More Forms > Modal Dialog | A pop-up form with OK and Cancel buttons | You need to collect input before continuing |
Create a form with the Form tool
- In the Navigation Pane, click the
Customerstable once to select it. - On the Create tab, click Form.
- The form opens in Layout view showing the first record. Click a text box and drag its edge to resize it; every control in the column resizes together because the tool places them in a layout.
- Press Ctrl+S, name the form (for example
frmCustomers), and click OK.
If the table is on the "one" side of a one-to-many relationship, Access also adds a datasheet of related records at the bottom. Delete it if you do not want it.
Create a form with the Form Wizard
- On the Create tab, click Form Wizard.
- Choose a table or query in Tables/Queries and move the fields you want into Selected Fields with the > button. To include fields from a related table, pick it in the same list and add its fields too.
- Click Next and choose a layout: Columnar, Tabular, Datasheet or Justified. If you chose fields from related tables, the wizard first asks how to view the data and offers a form with a subform.
- Click Next, give the form a title, and click Finish.
The wizard can only combine tables that have a relationship defined. Set relationships up first under Database Tools > Relationships.
Build a form from a blank form
- On the Create tab, click Blank Form. An empty form opens in Layout view with the Field List pane on the right. If the pane is missing, click Add Existing Fields on the Form Layout Design tab.
- Click Show all tables, then the + next to
Customers. - Double-click a field, or drag it onto the form. Add the rest the same way.
- Use the Header/Footer group on the Form Layout Design tab to add a title, logo or date.
- Save the form.
Layout view, Design view and Form view
A form has three views you will use constantly. Switch between them with the View button on the Home tab, or by right-clicking the form's tab.
| View | Shows data | Use it for |
|---|---|---|
| Form view | Yes | Entering and editing records |
| Layout view | Yes | Resizing and rearranging controls while seeing real data |
| Design view | No | Fine positioning, sections, and controls or properties that Layout view does not expose |
In Design view the ribbon shows Form Design, Arrange and Format tabs. In Layout view the first of those is called Form Layout Design. Older versions of Access labelled these tabs "Design" under a "Form Design Tools" heading.
To change a property, press F4 (or Alt+Enter) to open the Property Sheet. The two properties that matter most:
- Record Source (form, Data tab): the table or query the form reads.
- Control Source (each control, Data tab): the field the control is bound to.
Add controls
In Design or Layout view, pick a control from the Controls gallery and click on the form.
- Text box: the default for most fields. Leave Control Source empty for an unbound box, or enter an expression such as
=[Quantity]*[UnitPrice]for a calculated one. - Combo box: a drop-down list. With Use Control Wizards switched on in the gallery, a wizard asks where the values come from and which field to store the choice in.
- Button: the wizard offers ready-made actions such as Save Record, Close Form and Open Report, and writes an embedded macro for you.
- Subform/Subreport: shows related records, such as a customer's orders, inside the main form.
- Tab control: splits a crowded form into pages.
Set the order in which the Tab key moves between controls with Tab Order on the design tab.
Make the form safer for data entry
On the form's Property Sheet, Data tab:
- Allow Additions, Allow Edits, Allow Deletions: set to No to block those actions.
- Data Entry: Yes opens the form on a blank new record and hides existing ones.
- Recordset Type: Snapshot makes the whole form read-only.
On individual controls, Locked = Yes prevents edits and Enabled = No greys the control out. These settings guide users; they are not security, because anyone who can open the tables directly can bypass the form.
Open the form automatically
To show a form when the database opens, go to File > Options > Current Database and choose it under Display Form. Hold Shift while opening the database to skip it.
Troubleshooting
#Name?in a control. Its Control Source names a field that is not in the form's Record Source, usually after a field was renamed or removed. Correct the Control Source or delete the control.#Errorin a calculated control. The expression refers to something invalid, or the control has the same name as a field used in its own expression. Rename the control (for exampletxtTotal).- The form opens blank, with no controls visible. The record source has no records and additions are not allowed, or the query behind the form is not updatable. Check Allow Additions and open the query on its own.
- You cannot edit anything. Check Allow Edits and Recordset Type, and whether the form is based on a read-only query (totals queries,
DISTINCTqueries and many multi-table joins are read-only). A database opened from an untrusted location with content disabled also blocks macros behind buttons. - Controls will not move independently. They are in a layout. Select them and choose Arrange > Remove Layout.
- The Form button is greyed out. Nothing is selected in the Navigation Pane, or the database is open read-only.
Further reading
Get the weekly commit
New database deep dives every week.
