Don't want to update subforms, how can I accomplish this?

[ABL]

I have a form, vendor, and a subform vendor_contacts. When I load a vendor,
it's related contacts (multiple records) load in the sub form. However, I
need to save (or not) the subform (all records) and form at the same time.

I have tried using bAllowSave with me.vendor_contacts.form.dirty = False,
but I can't seem to get the subform NOT to save on exiting from the subform.

Any help would be appreciated.

Thanks,
Alden

PLEASE respond to the news group, as I do not check this account and I use
it to catch unsolicited emails.

 

[Rick Brandt]

I have a form, vendor, and a subform vendor_contacts. When I load a vendor,
it's related contacts (multiple records) load in the sub form. However, I
need to save (or not) the subform (all records) and form at the same time.

I have tried using bAllowSave with me.vendor_contacts.form.dirty = False,
but I can't seem to get the subform NOT to save on exiting from the subform.

What you're asking is not possible. The closest work-around is to bind your
forms to work tables, populate them with a copy of the live data which you can
mess with to your hearts content, and then use queries to send the changes back
to the live tables when finished.