Force a new form

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

Guest

I need to know how to force a Form to display a new input page when the form is opened up so that a user does not overwrite existing records. I do not want to restrict the user from being able to view existing records, just want to force a new data entry page when the the user starts up Access.
 
Set the Data Entry property of your form to Yes.

Lynn Trapp
MS Access MVP

Tahir said:
I need to know how to force a Form to display a new input page when the
Click to expand...
form is opened up so that a user does not overwrite existing records. I do
not want to restrict the user from being able to view existing records, just
want to force a new data entry page when the the user starts up Access.
 
I need to know how to force a Form to display a new input page when the form is opened up so that a user does not overwrite existing records. I do not want to restrict the user from being able to view existing records, just want to force a new data entry page when the the user starts up Access.
Click to expand...

Put the following code in the Form's Open event:

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acNewRecord
End Sub
 
Back
Top