How do I save changed records safely in an Access Database table?

[Guest]

We are using Access database tables with information in several columns. We
filter by form on specific columns to locate data and make any necessary
changes in appropriate columns of a record. Sometimes the filter will find 4
records but a change will be made to maybe only 1 or 2. We have found that
if those changes are made and the save button is used during the filtering
process, we do not always find these changes made when we go back and open
that table. Do you always have to close the filter and save any changes, or
can you save these changes during the process without having to go through
those extra steps? Do you have to save each record you change individually?
What is the safe procedure for saving changed information when using the
filter by form?

 

[Rick Brandt]

We are using Access database tables with information in several
columns. We filter by form on specific columns to locate data and
make any necessary changes in appropriate columns of a record.
Sometimes the filter will find 4 records but a change will be made to
maybe only 1 or 2. We have found that if those changes are made and
the save button is used during the filtering process, we do not
always find these changes made when we go back and open that table.
Do you always have to close the filter and save any changes, or can
you save these changes during the process without having to go
through those extra steps? Do you have to save each record you
change individually? What is the safe procedure for saving changed
information when using the filter by form?

Acces automatically saves edits when you change records or close the form.
Unless you see error messages the changes *should* be getting saved.

There is a bug if you are using a custom Close button where records with illegal
changes are silently not saved, but as long as you use the standard close button
that should not be an issue.