You could simply set focus to a control on the page and that page will be the active one when form opens. Probably doable wit a macro (I don't use them either so just guessing) but code would look like
Private Sub Form_Open(Cancel As Integer)
EDIT - forgot to mention that I didn't include a test for new record because how form is being opened wasn't specified. Could be OpenArgs or even a duplicate of a form that's just for editing or appending records (which isn't the best method) or some other undisclosed method.