CODEWITHSUNDEEP
ms-accessms-access-2010
Tom Gross
Tom Gross

Reputation: 191

How to open Form in Add record

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.

Upvotes: 19

Views: 137147

Answers (3)

HansUp
HansUp

Reputation: 97101

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

Upvotes: 23

RussWill
RussWill

Reputation: 201

On the property sheet, set "Data Entry" to Yes. You can turn off navigation buttons too.

Upvotes: 9

Conrad Frix
Conrad Frix

Reputation: 52645

In the Form_Load event use the GoToRecord Method of DoCmd and pass in acNewRec for the Offset.

Private Sub Form_Load()
   DoCmd.GoToRecord , , acNewRec
End Sub

Upvotes: 13

Related Questions