How to open Form in Add record

ms-access ms-access-2010
Tom Gross picture Tom Gross · Feb 23, 2012 · Viewed 113.3k times · Source

I have a form to input records to a table. I would like it to open on an empty add (New) instead of displaying the first record of the table. To be used by a Navigation Form which opens the input form from a button.

Answer

HansUp picture HansUp · Feb 23, 2012

You can use acFormAdd (value = 0) as the optional DataMode argument to OpenForm. Access' help describes acFormAdd as "The user can add new records but can't edit existing records." And actually, not only does that prevent editing of existing records, they are not even displayed in the form with that option. 

DoCmd.OpenForm "frmaw_save",,,,acFormAdd

If you want to always use the form that way, you can set its Data Entry property to Yes (on the Data tab of the form's property sheet).

Related questions

How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am stuck as it is throwing an error: Too few parameters. I have a table test with only one column in …

Read More
Corrupted Access .accdb file: "Unrecognized Database Format"

I'm having a problem. One of my databases on our shared network will not open for any user. It says "Unrecognized Database Format." I've had this problem before but was still able to open the database, compact and repair, or …

Read More
Access 2010 VBA query a table and iterate through results

I have a query that I want to execute against a table. With the results I want to do something. In my head the pseudo code is: var q = "select * from table where some condition"; var results = db.getResults(q); …

Read More