New record when opening Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

Upon opening a form I would like the form to default to a new record.
Additionally I would like all old records to be hidden from the form view.

Any ideas how to make this happen?

Many thanks
 
JaB said:
Hi there

Upon opening a form I would like the form to default to a new record.
Additionally I would like all old records to be hidden from the form view.

Any ideas how to make this happen?
Click to expand...

Forms have a property named DataEntry. Setting that to True ("Yes" in the
property sheet) produces that behavior.
 
Two ways
1. Set the form DataEntry Property to Yes
====================================
2. On the On open form command line, specify that it for data entry
docmd.OpenForm "FormName",,,,acFormAdd
 
Back
Top