set default view on Access form

[Guest]

I'm settting up a database for other users to enter data. I have it set so
that when the file is opened, the data entry form opens, but I can't figure
out how to get it to open as a blank form, rather than showing a record.
Since other people will be inputting the data, I want it to be blank.

 

[Allen Browne]

Create a macro, and save it with the name AutoExec.
It will run every time the database is opened.

In the macro, use the OpenForm action.
In the lower pane of macro design, set Data Mode to:
Add
It will open to a new record.

 

[Guest]

Open your form in design view.
Open the properties dialog
Goto the 'Data' tab
Change the 'Data Entry' property value to True

 

[Guest]

If your users will only be entering new records and not editing exiting
records, you can set the form's Data Entry property to Yes. This will show a
blank form when opening and the users can enter data; however, they will not
be able to view or modify existing records.

The other method, if users will be entering new records as well as editing
existing records, is to go to a new record in the Load event of the form.
Docmd.GotoRecord acNewRec