how do I make a table default to a new record/save-new record butt

[Guest]

Ok my question is a two parter.
1. When I created my database and opened it up it defaulted to the first
field in a new record. I would input data save, close, and when I opened it
back up it defaulted to a new record. Somehow (i'm assuming I changed
something) now it defaults to the first field in the first record that I ever
entered.(a field that allready has data in it). I'm trying to figure out how
to get it back to the way it is, because when I imput data using a form I
want it to bring up a blank record when I open the form.(and I'm assuming
that they are tied together)

2. Is there a way that I can make a button for my form that saves the record
and advances to a new record with one click?

Thanks for any help you can offer

 

[John Vinson]

Ok my question is a two parter.
1. When I created my database and opened it up it defaulted to the first
field in a new record. I would input data save, close, and when I opened it
back up it defaulted to a new record. Somehow (i'm assuming I changed
something) now it defaults to the first field in the first record that I ever
entered.(a field that allready has data in it). I'm trying to figure out how
to get it back to the way it is, because when I imput data using a form I
want it to bring up a blank record when I open the form.(and I'm assuming
that they are tied together)

You can set the Form's DataEntry property to True; this will let you
enter new records, but will not let you view old ones.

A bit more flexibly you can put the following code in the Form's Load
event:

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord acNewRecord
End Sub

2. Is there a way that I can make a button for my form that saves the record
and advances to a new record with one click?

ummmm... sure... but why bother? If you tab out of the last field in
the Form's tab order, it will save the record, move to the first field
in the new record, and let you keep entering data.

John W. Vinson[MVP]