Inserting a New Record into a Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 05 Jul 2006 23:51 GMT

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

Reply to this Message

Larry Linson - 06 Jul 2006 07:20 GMT

> What is the best of way of inputting
> new data into an exiting table. I have
[quoted text clipped - 5 lines]
> 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

Reply to this Message