Command Button

I'm learning as I go with Access, but I have come across a problem that I can't seem to figure out. I have a button that I have set to open a form, however I need it to open the form with a new record as the default and I can't figure out the code. Please help!!!

Is the form you are trying to load a bound or unbounded form?

it's an unbound form

I tried to add an on open event and I keep getting errors. The code I'm using is probably wrong. Here is the code I'm using:

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec 'Add a new record.
LastName.SetFocus 'Move focus to Last name field.

End Sub

Also I'm sorry becuase it is a bound form not unbound. Can you let me know?

Put you code in Form_Load

S-

I put the code on_load event and now I'm getting a run-time error: 424 and when I go to debug it is highlighted on this line:
LastName.SetFocus 'Move focus to Last name field. Any ideas why? It is also saying Object Required

Does LastName exist as a text box.

The error is referring to that fact that the object (LastName) doesn't exist

S-

Thank You very very much that worked