title: Can I wrap an Access form with a transaction?
body: <p>I want to make a form the essentially creates an invoice, but using some other related data as inputs or limits;  In the process of adding items to the invoice, I need to reduce the items in another table.   Since the user will enter several items at a time, I'd like to issue a "START TRANSACTION" when the form loads, and then do a "COMMIT" when the form updates.   Thus, if they cancel the form, the other related tables (shown via subforms) would roll back to the previous values.</p>