What "open to new record" means and why you'd use it

When you create a form in Microsoft Access, it starts out set to show existing records in your database. If you want the form to let people add brand-new records instead — or in addition — you need to change a setting called Allow Additions. This is what "open to new record" means in Access language: the form is configured to accept data entry for records that don't exist yet.

You might want this if you're building a form for staff to log customer calls, or for volunteers to sign up for shifts, or for anyone who needs to add information to your database without touching the underlying tables directly. The form becomes a controlled entry point where people fill in fields and click Save, and Access handles putting that data in the right place.

By default, Access forms can do this. But if someone has locked it down — or if you inherited a form that only displays old records — you'll need to unlock it. The steps are the same whether you're using Access 2019, 2021, or Microsoft 365.

Key Takeaways

  • Access forms have an Allow Additions property that controls whether new records can be entered; it's usually on by default but can be turned off.
  • To turn it back on, open the form in Design View, open the Property Sheet, and change Allow Additions from No to Yes.
  • You can also set Allow Deletions and Allow Edits at the same time to control what people can do with existing records.
  • Once you save the form, anyone who opens it will see a blank record ready for data entry, plus navigation buttons to move between old records.

Opening the form in Design View

Start by opening Access and the database that contains your form. In the left sidebar under Forms, right-click the form you want to change. A menu will pop up. Click Design View. The form will open in edit mode, showing you all the fields and controls you can adjust.

If you don't see a sidebar on the left, go to the View menu at the top and click Navigation Pane. That will bring it back. Once you're in Design View, you're ready to change the form's properties.

Finding and changing the Allow Additions property

With the form open in Design View, you need to open the Property Sheet. This is a panel that shows every setting for the form. On the Design tab at the top, look for a button labeled Property Sheet (it usually has a grid icon). Click it. A panel will appear on the right side of your screen.

At the very top of the Property Sheet, make sure you're looking at the form itself, not a specific field. You should see a dropdown that says Form. If it says something else, click that dropdown and select Form.

Now scroll down in the Property Sheet until you find Allow Additions. It will show either Yes or No. If it says No, click on it and change it to Yes. That's the whole change. You don't need to adjust anything else unless you want to control whether people can edit or delete existing records.

Understanding Allow Edits and Allow Deletions

While you're in the Property Sheet, you'll see two related settings right near Allow Additions: Allow Edits and Allow Deletions. These control what people can do with records that already exist in the database.

Allow Edits set to Yes means people can change data in old records. Set to No means they can only view them. Allow Deletions set to Yes means people can remove records entirely. Set to No means they can't. Most forms have both set to Yes, but if you're building a form where people should only add new data and never touch the old stuff, you'd set Allow Edits to No and Allow Deletions to No, while keeping Allow Additions at Yes.

For now, if you only care about new records, just make sure Allow Additions is Yes and leave the other two alone.

Saving the form and testing it

Once you've changed Allow Additions to Yes, save the form. Press Ctrl+S on your keyboard, or go to File and click Save. Access will save the change.

Now switch to Form View to test it. On the Design tab, click View and select Form View. The form will switch from edit mode to the way users will see it. You should see a blank record with empty fields ready for data entry. At the bottom of the form, you'll see navigation buttons that let you move between records. If you see a blank record and those buttons are active, the form is now open to new records.

Try typing something in one of the fields and then press Ctrl+S to save. If the data sticks and a new blank record appears, you're done. The form is working.

What to do if the form still won't accept new records

If you've set Allow Additions to Yes but the form still won't let you enter data, check two things. First, make sure the underlying table isn't read-only. Right-click the table name in the left sidebar, click Properties, and look for a read-only checkbox. If it's checked, uncheck it.

Second, check whether the form is based on a query instead of a table. Some queries are read-only by design — especially if they join multiple tables or use certain functions. If that's the case, you may need to rebuild the form to pull from the table directly, or ask whoever built the query to adjust it. This is less common, but it's worth checking if nothing else works.

Frequently Asked Questions

Can I make a form open with a blank record automatically?

Yes. In Design View, open the Property Sheet, find Data Entry, and set it to Yes. This makes the form skip all old records and show only a blank one when someone opens it. They can still navigate to old records using the navigation buttons at the bottom, but they start fresh.

What's the difference between Allow Additions and Data Entry?

Allow Additions lets people add new records and also view old ones. Data Entry set to Yes hides old records entirely and shows only blank ones. Use Allow Additions if you want a mixed form; use Data Entry if you want a pure entry form.

If I set Allow Edits to No, can people still add new records?

Yes. Allow Edits controls whether people can change existing records. Allow Additions controls whether they can create new ones. You can have one on and the other off.

Do I have to be in Design View to change these settings?

Yes. You can't change Allow Additions from Form View. You have to go into Design View, adjust the Property Sheet, save, and then switch back to Form View to see the change take effect.