Rookie question on initializing a form to a New record

[lowells]

I inherited a database with a form for entering data. I would like the form to load and be at the New record. Currently, it is loaded to the first record and I have to then click the New record button provided at the bottom of the form to pull up the "(New)" record for data entry. How do I do that? Thanks.

[CJ_London]

set the form dataentry property to Yes?

[Missinglinq]

If you only want to be able to Add New Records (but not Edit existing Records) Ajax's suggestion is fine. (DataEntry = Yes)

To Open the Form directly, in that Form's code window:

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

To Open Form from another Form:

DoCmd.OpenForm "Form1", , , , acFormAdd ''' The user can add new records but can't edit existing records.

OR

DoCmd.OpenForm "FormName", , , , acFormEdit ''' The user can add new records and edit existing records.

Linq ;0)>

[lowells]

Thanks! DoCmd.GoToRecord worked for me.

[Missinglinq]

Glad we could help!

Welcome to AFN!

Linq ;0)>