DataChange Event

[MarionD]

Hi there,
Can someone tell me exeactly what triggers the datachage event of a form?

This is the task I have:

If the data is changed in any way in the "static data" used for billing, I have to create a copy of the record using the changed data, and mark the current record as "old record". the object being that if there are accounts linked to the old record, the account is still OK.

This is the solution I've tried:
I can do this on the BeforeUpdate event using if me.dirty then..., but if they change the data, then undo the change, it also creates a new record. I could check each element against .oldvalue... but this seems to me like spaghetti code?

Problem:
The datachange sounds as though it should trigger if the data is changed, but it doesn't?

I'm usung XP. Datachange is mentioned in the help, but not very clear.

Thanks a lot
Marion

 

[aleb]

Macro or function that runs when PivotTable triggers its DataChange event

 

[MarionD]

Hi Alexi - is it triggered only in Pivot table?

 

[aleb]

I think it is ...
at least this is what the status bar says when you put the cursor on the datachange event.

 

[MarionD]

Thanks! Pity it would nice if it was triggered when the data is changed in a form! Looks like I'll have to go with my before Update event!