On Dirty event of form

[Eric Blitzer]

If i trigger a save record event in the forms on dirty
event what happens.
Does it save the record if changes are made when I got to a
new record?
Does it save the record every time a control is changed?

Thanks

 

[Wayne Morgan]

I haven't tried it, but I would expect it to "immediately" save the record
every time a control's value is changed. It would not fire every time you
moved to a new record, that would be the form's Current event.

I say "immediately", because when you go to save the record, the form's
BeforeUpdate event will fire before the record is actually saved and
perhaps, depending on the timing, the dirty control's AfterUpdate event. The
control's BeforeUpdate event should have fired before the form became dirty.