Inserting a New Record into a Table

[Guest]

What is the best of way of inputting new data into an exiting table. I have
setup a form that links to the table with a save record command button, but
each time I open the form, it displays the data from the first record in the
table. I want all of the fields to be blank - I would like it to be inserting
a new record in the table.

Any help would be appreciated.

Paul

 

[Larry Linson]

What is the best of way of inputting
new data into an exiting table. I have
setup a form that links to the table with
a save record command button, but
each time I open the form, it displays
the data from the first record in the
table. I want all of the fields to be blank -
I would like it to be inserting
a new record in the table.

Take your choice:

If you've left the Navigation controls on the bottom of the Form, you can
click the one marked >*, which will move to a new record,

or

In the Data tab of the Form's Property Sheet, set the Data Entry property to
Yes, in which case, it won't display anything but new records.

If your Form is bound, I am at a loss to understand why you need a "Save
Record" button, as Access will automatically save when you move off that
record, or close the Form, or move the cursor into a Subform Control, and
possibly a few other pertinent times.

Larry Linson
Microsoft Access MVP