Changed data property

  • Thread starter Thread starter Tony Nichols
  • Start date Start date
T

Tony Nichols

I need to test for a data change to the data behind a
subform. Can anyone tell me a property I can check to
determine if the data set of the subform has changed?

Thanks in advance for any assistance.

Tony Nichols
 
Perhaps, the Dirty Property of the Form being used as the Subform (more
technically accurate, being used as the SourceObject of the SubformControl).
Note that this only applies to the CurrentRecord on the Subform.
 
Van,

Thanks for the information. As you noted, the property
only applies to the current record. I would like to be
able to undo any changes to all records of the subform.
I am not sure that is possible. Well I should say
easily possible. I guess you could watch all changes
and write changes to a table and pull them back. But may
base problem is with mutliple users and a single
temporary table.

Thanks again,
Tony
 
There are a work-around using temporary Tables both for the "One" Table and
the "Many" Table. When the user enters / edits Records, he/she actually
does it on the temporary Tables. Onnce it's all finished, the user can
click a "Save" button to save / update the Records from the temporary Tables
to the permanent Tables.

It is very messy though and require a fair bit of coding to get it right ...
 
Back
Top