Data/data set change event

[HB]

I have code in my parent form I need to run after a subform inserts, updates,
or delteles a record. Sholuld I just put the call in those events or should I
use the Data or data set property? What is the difference? The f1 help was
not that great.

tia

HB

 

[Brendan Reynolds]

I think you mean the On Data Change and On Data Set Change properties? If
so, my understanding is that those apply only to Pivot Table View.

 

[HB]

Yes, you're right. Further exploration of the help explained that.

Thanks. I guess there is no global "data change" event for the
recordsource, I have to code for inserts, updates, and deletes separately.

 

[Brendan Reynolds]

You may not have to code for inserts and updates separately, unless you need
to distinguish between them The BeforeUpdate and AfterUpdate event
procedures are fired whenever a record is saved, regardless of whether the
record was saved as a result of inserting a new record or an update to a
previously inserted record.