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

4
votes

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....

2
databasems-accessvba
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) - hawbsl

2 Answers

16
votes

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.

0
votes

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.;