make new record default

[Guest]

I would like my database to have a certain feature. I want to make my form
default to a new record everytime a user starts working on it. In other
words, everytime the form is open to enter information I want a new record to
appear instead of record 1 (the very first record). The reason is to protect
the information already in my database by not letting users overwrite the
information, and at the same time to make the work easier for the users. How
can I do that?
Miguel

 

[Guest]

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

 

[BruceM]

Does that differ from Me.Recordset.AddNew? Just curious.

 

[Guest]

I'm not sure what is the Me.Recordset.AddNew and how you use it, I tried it
in the form load and I got an error.

the two example I gave are to be used when you want the form to be open for
data entry only, without ability to update existing records

 

[BruceM]

I got the line from a newsgroup posting somewhere when I was setting up a
database. I use it in the form's Open Event, but Data Entry is set to No.
I had thought that Data Entry being set to Yes caused the form to open to a
new record without any additional prompting.
I ask because soon I will be deploying a database in which existing records
are protected from changes, and I want to line up in advance as much
information as may be helpful.