Open form to new record (Windows 2000)

[lockwoodbf]

Stupid question: How do you open a form to a new record when you click on the form or a shortcut to the form. Mine keeps opening to the first record of the database.

[Gastly]

You can make a macro to open the form.
Choose OpenForm
Set the Data mode to Add

[HansV]

If you want to use the form ONLY to enter new records, set its Data Entry property to True in design mode.

If you want all existing records to be visible, but to start on a new record, write code in the On Load event of the form.
- Open the form in design view.
- Activate the Event tab of the Properties window.
- In the On Load event, select Event Procedure from the dropdown list.
- Click the ... to the right of the dropdown arrow.
- Make the code look like this:

Private Sub Form_Load()
RunCommand acCmdRecordsGoToNew
End Sub

- Switch back to Access, close and save the form.