VBA code to open MS Access form to new, blank record

[Will M]

I saw this question elsewhere on this site, but it was five years old, so I'm asking anew . . .

I want to open a form in Access 2007 (on WinXP) by clicking a button on a different form, and I want the form to open with blank fields, to create a new record in the underlying table.

My code is as suggested in the five-year-old posting, but it doesn't work:

Private Sub btnSetNewGroup_Click()
  DoCmd.OpenForm "frmGroupBasics", , , , acFormAdd
End Sub

What happens is that the form opens to the first record in the table, with the first field highlighted.

Any ideas what's lacking?

[neelsfer]

try this in On load

 DoCmd.GoToRecord , "", acNewRec

[NeoPa]

The only thing I can think might be happening (as using acNewRec is similar to what you've already tried with acFormAdd) is that the design of the form might be set not to allow these options. You should check the property = AllowAdditions.

[Will M]

Thanks! I was thinking I needed to specify the new, blank record from the calling control -- didn't think of putting it in the form being opened.