How to add new record to table in Ms Access by form?

I made form by wizard, but when I run this, first I have in fields first record from table, and I can edit this record, but I don't want to have this. I want to have blank field and when I click add button i can add new record, not edit.

15.9k 25 25 gold badges 74 74 silver badges 117 117 bronze badges asked Oct 20, 2010 at 18:05 4,824 11 11 gold badges 40 40 silver badges 41 41 bronze badges

When you talk about clicking on an "Add" button, do you mean one you've created and put on the form or do you mean the built in Add button that Access provides in the Navigation area (marked with a star)

Commented Oct 20, 2010 at 18:16

2 Answers 2

Change the form's properties:

AllowEdit = False to prevent changing existing records
and/or
DataEntry = True to arrive on the New Record whenever the user opens the form.

answered Oct 20, 2010 at 18:18 25.1k 12 12 gold badges 94 94 silver badges 155 155 bronze badges

I've got exactly the same problem as kspacia, but I work with Access 2007 and I don't find those properties. Someone could help? thanks.

Commented Jan 14, 2021 at 8:29 @Uwe_98 those form properties are definitely there, even in Access 2003 Commented Jan 16, 2021 at 13:38

Create a macro for this. 1. In create tab select macro. 2. Under cation field in macro select open form. 3. Below in property box select the form you want to perform task with 4. Then in Data Mode select Add.

Then when ever you run this Macro your form will open to enter a new record and not editing existing record.

The only problem here would be when you open form then it will open in edit existing record mode but when you open corresponding macro form will open in add mode, so in order to counter this you can name your Macro as AutoExec so the macro will run itself when you open the database.;