Input Form - How to force blank record shown initially

[FriQenstein]

Greetings all,

I'm having to redo some of my input Forms, and I'm having a little bit of grief.

The form itself is fine, and works accordingly, however when viewing it in Form view so that I can test the data entry, it always defaults to showing the first record in the Table.
I have to click the little arrows at the bottom of the Form to either skip to the last record, or actually click the New Record button in order to get the form to display blank fields to be filled out.

My question is, because I hide all of the record controls when this is being used by 'normal' users, how do I get the input Forms to open up with no data being displayed from the Table initially? Basically have it automatically jump past the last record so the user can enter a new item.
Otherwise, they may edit the existing fields already displayed, and that will in turn changed the data that is already in the Table.

I hope I explained that well enough.


Regards.

[Missinglinq]

You really have to open to a new Record:

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

If you only want users to enter new Records...without being able to see/edit existing Records...set the Data Entry Property of the Form to Yes.

Linq ;0)>

[FriQenstein]

Awesome.
Thanks for that bit of information. Worked like a charm.

Regards.

[Micron]

methinks you can also open the form in data entry mode. That should give you the option of opening it one way for users, another way for yourself (or can be dependent on user permission level)