Protect form & open form to blank upon entry

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.
 
T

Tom van Stiphout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open to Blank Form 5
How do I clear a form? 0
opening blank form upon open 3
Trick filter form combo with DoCmd.OpenForm and Data Entry property 1
Trouble opening to blank form 22
Cannot Get Blank Form To Open For NEW Data Entry 8
blank form, can't insert new record 11
Opening a blank form 1

Top