have autonumber set. How do I set as default entry for form?

[Sean]

Not sure what happened. Was set to go right to new record entry with
autonumber when opening form.
Now it opens to the very first record in database and you have to got to end
to get new record entry.
How can I change this back to have the new record entry as the default view?
Thanks

 

[Lynn Trapp]

Set the Data Entry property of the form to Yes.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Sean]

Thanks. Worked. Guess it was changed accidently.

 

[Sean]

Hmm. When set to that, now I cannot cycle thru exisitng records as well.
Allow edits, and additions is enabled as well.

 

[Lynn Trapp]

The add the following to the Open event of your form

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToRecord , , acNewRec

End Sub

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[John Vinson]

Hmm. When set to that, now I cannot cycle thru exisitng records as well.
Allow edits, and additions is enabled as well.

I don't like Data Entry mode for this very reason. Sometimes you want
to default to the new record but still have the ability to go back.

Try putting code in the Form's Activate event:

DoCmd.GoToRecord acNewRecord

When you open the form, or navigate back to it from another form, this
will go to the new record.

John W. Vinson[MVP]