Difference between "save record" and "add new record"

cochese

Registered User.
Local time
Today, 13:41
Joined
Feb 5, 2008
Messages
54
I feel silly asking this, because I'm thinking it's very obvious. So obvious I can't find a search result here or on Google because no one can't figure it out but me.

Maybe it's how I'm using it...which is I have a form that is used for data entry only (no ability to cycle through existing records or edit them, and on that form the user enters information that gets saved to a table as a new record.

The only difference I find is that "add new record" adds the record and clears the fields, while "save record" adds the record and keeps the entered data in the fields.
 
I feel silly asking this, because I'm thinking it's very obvious. So obvious I can't find a search result here or on Google because no one can't figure it out but me.

Maybe it's how I'm using it...which is I have a form that is used for data entry only (no ability to cycle through existing records or edit them, and on that form the user enters information that gets saved to a table as a new record.

The only difference I find is that "add new record" adds the record and clears the fields, while "save record" adds the record and keeps the entered data in the fields.

Not exactly.

With any record navigation (new or existing record) or the closing the form Access will automatically save the current record's changes before moving on.

Here are some examples:

When you save a record the changes to the record are saved by committing the changes to the to the table. There is no record navigation. You are still on the same record.

When you navigate to a different record Access automatically saves any changes to that record. Id does not matter if you navigate to an existing record or a new record, Access swill automatically save the changes to teh current record before it navigates.

Adding a new record is a type for record navigation which is moving to a new record. Since this is a type of record navigation, Access will automatically save the current record before moving to the new record.

If you make changes to a record and then navigate to the previous existing record this is another type of record navigation. Access will automatically save the current record before moving to previous record.
 

Users who are viewing this thread

Back
Top Bottom