I'm new to instruction but will give this a shot... I'm also assuming you're trying to open your form onto a blank record so you that you can add a new record...
Have you tried this?
Click DESIGN view, in the upper left you'll see a black box, dbl-click or just right the black box and select PROPERTIES,
Select the EVENT tab, Select "On Open" (at top) and click in the empty space, an arrow and 3 bars appear (the menu). Select the menu, then out of the options select CODE builder.
This is where your form's vb code is added, which MS Access will automatically supply the intro and exit code for your event...
DoCmd.GoToRecord , , acNewRec
me.[whateveryourfirstcontrolis].setfocus
So your entire code should look like this:
Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
me.[whateveryourfirstcontrolis].setfocus
End Sub
Click X to exit the code panel, then again. You can now go from DESIGN to FORM view or close and reopen the form. Your form should now open to a blank record for you to add a new entry with your cursor at whatever control you set the focus to...
Note: The next time you go into design view/properties/event, you'll see "Event Procedure on the On Open event... this also applies if you create a macro or build an expression. These events are also on every control (element you use on your form).
PS: Once you get to the bottom control, if you want to just cycle through the current record and not go to the next record, go back into the properties again, select the OTHER tab, select CURRENT RECORD.
Hope it helps.
:) Lisa B.