Bound Form opens to new record

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

We have a bound form that opens by default to the first of several thousand
records. We'd like the form to automatically open to a new blank record.
What code is necessary to do this?

Thanks in advance.

Mark
 
mark said:
We have a bound form that opens by default to the first of several
thousand records. We'd like the form to automatically open to a new
blank record. What code is necessary to do this?

Thanks in advance.

Mark
Click to expand...

Use the optional acFormAdd argument if opening from code or set the
DataEntry property of the form to Yes in design view.
 
mark said:
We have a bound form that opens by default to the first of several thousand
records. We'd like the form to automatically open to a new blank record.
What code is necessary to do this?

Thanks in advance.

Mark
Click to expand...

You can also add code such as this to your form's On_Open event, and it will
always run. You won't have to hunt down all buttons that open the form.

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

Using DataEntry hides all existing records, though this may be what you're
looking for.
 
Back
Top