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

  • Thread starter Thread starter ABL
  • Start date Start date
A

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.
 
ABL said:
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.
Click to expand...

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.
 
Back
Top