Starting on a blank record rather than a previous record

[Guest]

Here is my problem: I have a subform where users go in monthly and enter data
so after 3 months there are 3 different entries, so there is now autonumber
1, 2, and 3. My question is when I open the form how do I get the form to
start on a blank entry rather than entry 1? I have tried using the "data
entry" property in the property box but I still want to be able to edit other
records so that does not work. Thanks for any help in advance.

 

[Guest]

You can have it call a macro on open and that macro action GoTo Record - New.

 

[missinglinq via AccessMonster.com]

Why use a macro? why not simply:

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