if your form and subforms are a single form, don't bind the data to
your tables and do the updates using a 'save' button
if any form / subform is a continuous form, you need to store the data
somewhere, it can only handle one record at a time
it might look like a big excel worksheet but it isn't, so if you don't
want to update the actual table, you'd need to create a temp table with
the temp data, that again gets updated using a 'save' button
or write the original data to a temp table, bind everything to the
actual table and provide an 'undo' button that copies the temp data
back
icedgar wrote:
I posted a question about this very same thing. Does anyone have any
ideas that would allow someone to move between sub-forms while
makeing changes and once you move to a new record or exit out of the main
form it prompts you to save. If you don't save, then it will revert all
the subform changes back. Is this even possible in Access? I currently
have a Before Update script that prompts to save. The problem with
that is it's very monotonous. Everytime I move from a subform to
another or the main form, it prompts you to save. I would be nice to
have a prompt after all the changes have been made.