Best way to check a form for updates before closeing

[dniezby]

Anyone have code for checking a form for updates (not just dirty) before closing a form?

Right now I just have this.

Private Sub Form_Close()
'If the form has modified update the modified date

If Me.Dirty Then
    
    Me.Modified = Now()
    
Else
    DoCmd.Close


End Sub

The only issue is, what if the person doesn't actually update any of the data? I don't want the modified timestamp to change unless they actually change the physical data.

[pbaldy]

I would like expect testing dirty to work. Does it not? The before update event should only fire if they changed something. If you want to make sure they didn't change it back, you could loop the controls and compare the Value and OldValue properties.

[Missinglinq]

A couple of things:

The Form_Close event is too late for this...the Record is already saved by the time it executes, and hence is no longer Dirty.

Having DoCmd.Close in this event is going to pop an error...it's actually going to prevent the Form from closing, which it was already set to do.

As Paul suggested, you'll need to check, in the Form_BeforeUpdate event, whether any Control has actually been changed, and assign Now() to Modified, if it has.

Linq ;0)>

[dniezby]

A couple of things:

The Form_Close event is too late for this...the Record is already saved by the time it executes, and hence is no longer Dirty.

Having DoCmd.Close in this event is going to pop an error...it's actually going to prevent the Form from closing, which it was already set to do.

As Paul suggested, you'll need to check, in the Form_BeforeUpdate event, whether any Control has actually been changed, and assign Now() to Modified, if it has.

Linq ;0)>

So it looks like I was doing it right in the first place.

I already have this in my form's before update

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Modified = Now()
End Sub