Protect form & open form to blank upon entry

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I am new to Access. I have created a form. I would like the existing data
to be protected (not manipulated) and I would like the form to open to blank
upon entry. I tried the suggestion Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRecord
End Sub
Unfortunately, I received a runtime error. And I verified the Allow
Additions property was set to yes. Hoping someone can assist. Thanks.
 
On Tue, 11 Aug 2009 06:01:02 -0700, Cathy

The statement is:
DoCmd.GoToRecord , ,acNewRec

To protect existing records, in the Form_Current event you can write:
Me.AllowEdits = Me.NewRecord

-Tom.
Microsoft Access MVP
 
Back
Top