If you are using docmd.openform to open a form you can use the Datamode
parameter:

docmd.OpenForm "MyForm",,,,acFormAdd

or

docmd.OpenForm "MyForm",datamode:=acFormAdd

Just to clarify, this isn't about how the *database* opens, it's about
how the *form* opens.  Maybe the database automatically opens the form
on startup, but it's the form we're concerned with.  At least, I trust
that it's a form you're talking about, and you are not opening a table
datasheet directly.  That wouldn't be a good idea.

There are two main ways you could approach this with your form.  The
simplest way would be to set the form's DataEntry property to Yes.
That's on the Data tab of the form's property sheet in design view.  If
the form is set to open in Data Entry mode, it only ever shows a blank
record to be filled in.  Once that record is filled in and the user
moves on to the next record, the old record disappears from the form.
The drawback to this approach is that you can't go back and review old
records using this form.

An alternative approach would be to open the form in normal mode, so
that all records are displayed on the form, but have it automatically go
to the new record.  The other records would be available by paging back,
but the form would open to a blank record, ready to fill out.  This
could be achieved by writing a little event procedure for the form's
Load event:

   Private Sub Form_Load()

       RunCommand acCmdRecordsGoToNew

   End Sub

As a third alternative (I know, I said two, before) if the form is being
opened by code, you could let that code determine whether to open the
form in data entry mode or in normal mode, and specify it in the
arguments to the OpenForm method.