Deleting the parent and children records works for new entries to the database.

I now need to be able to dump the form and subform changes, if the user
changes their mind on exisiting records. I want to keep the data that was in
the tables before they started editing the record.

"Rick Brandt" wrote:

dsc2bjn wrote:
If I do as you suggest, the user wouldn't be able to enter any new
(subform)records or update any (subform) records.

My gut is telling me to allow the data to be written to the (subform)
data table, and add a query command that on dirty for the main form
would delete the children records.

I was hoping for a simple solution.

Let both forms save as Access is designed to work and replace your "close
without saving" code with code that deletes the main record. If you have
your relationships set up properly that will also delete the child
record(s).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com