Capture Data Change in Subform Using a table as SourceObject

[Dan]

I need to capture data changes in a subform that uses a table as a
sourceObject.

Basing a subform on form isn't feasible as there are several tables that
could be used the sourceObject of the subform.

Capturing data changes are necessary as other records in the table may need
to be recursively updated based upon the data change.

How can I programmatically determine which row and column was changed and
what its new value is?

Thanks,
Dan

 

[Graham Mandeno]

Hi Dan

Sorry, there are no events associated with data change in tables. You will
need to create a form (continuous or datasheet) bound to each table and use
that as your SourceObject. Then you can make use of Form_AfterUpdate and
other events.

 

[KARL DEWEY]

How can I programmatically determine which row and column was changed and
what its new value is?
You could have duplicate textboxes, one set from your tables (bound to
fields) and another set of unbound textboxes and then have a query compare
the sets of textboxes. But this is for a single record.

One thing you might consider is to append a record to a table that collect
your changes so if any field is to change then append a record to the change
capture table. But you would also need to record the identity of the source.

I do not see how this is of any use if the source is not predetermined. How
will you be changing source for the form?