Form - Subform updates

[GJT]

I am still looking into the mist that is rollback using a replicated database........

What I need to do is to signal to the parent form when its subform has been updated.

When the subform is updated - the underlying tables immediately reflect the data that has been entered. I propose to use a boolean flag to indicate that changes have been made on the subform (in the Update event) but my query is : which event on the parent form do I use to check this flag value? This event must fire when either the parent form is closed or the user navigates to the next record......

NB. in this instance I have assumed that no changes have been made to the parent form. Otherwise, I could use a field specifically for this purpose but it would need to be linked to the source table for the Form_Update event to fire........not the best solution!

Any ideas developers?

 

[Rich]

Private Sub Form_Unload(Cancel As Integer)
If CanClose = False Then
Cancel = True

End If
End Sub

 

[GJT]

Rich - what about record navigation?

 

[Rich]

I find it easier to just hide then untill validated