Menu
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.
286
Add a record to a table or form. Open the table in Datasheet View or the form in Form View. On the Home tab, in the Records group, click New, or click New (blank) record, or press Ctrl+Plus Sign (+).
Click Current Database. Under Application Options, in the Display Form list, select the form that you want to display when the database starts. Click OK, and then close and reopen the database to display the startup form.
To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form. Access creates a form and displays it in Layout view.
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).
139
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
On the property sheet, set "Data Entry" to Yes. You can turn off navigation buttons too.
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
