Continuous Form do not allow updates until button click

[DoubleD]

Hi,

I have a bound continuous form which I filter on load. I have the following 2 questions:
1. Can I disable the automatic Add/Update until I click a button?
2. On button click can I only Add new records or update only the records that have been edited?

[mbizup]

Access does not have built-in 'batch processing' for continuous forms.

A work around is to set up a temporary table having the same fields as your main table, but without autonumber and Primary Keys attribute on the ID field, and use that temporary table as the recordsource for your continuous form.

Using VBA, Prior to opening your 'batch edit form' copy the needed records to the temp table. The records should preferably be queried/filtered in some way before this, so that the user is dealing with a manageable amount of relevant data.

The user can add to or edit the records in the Temp table through the user interface (the continuous form).

Through VBA again...

In a 'Cancel' button automate discarding the records in the temporary table.

In a 'Save' button, automate queries to update existing records and add new records from your temporary table to your main table. (Existing records can be identified and matched by the ID/PK field copied from the main table; new records will have this field in the temporary table null)

Code intensive? Yes!

[DoubleD]

Thank you mbizup. I will give it a try.