How do I get access to open up a blank form each time I select a f

  • Thread starter Thread starter tes
  • Start date Start date
T

tes

I use a switchboard to select the form I want to use. When I select the form
it is displayed with prior data I have entered. I would like a blank form to
be displayed upon selecting the form. I know I can set the DataEntry
property to NO but then I won't be able to see the existing records if I need
to.
 
I use a switchboard to select the form I want to use. When I select the form
it is displayed with prior data I have entered. I would like a blank form to
be displayed upon selecting the form. I know I can set the DataEntry
property to NO but then I won't be able to see the existing records if I need
to.
Click to expand...

Put code in the form's Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, acNewRecord
End Sub
 
Back
Top