Run a subroutine when record is changed

[bwyrwitzke]

This should be an easy one, but I can't seem to find the right command...

I have a two page form where I want either page 1 or page 2 to be displayed depending on a check box (checkSea). The code is below, I just don't know where to put it so it runs each time the user changes records.

Private Sub CheckPage()
DoCmd.GoToPage 1

If checkSea Then
DoCmd.GoToPage 2
End If

End Sub

I've tried running the sub on Form_Load, and others but no luck. Any help would be appreciated. Thanks.

Bruce

 

[bwyrwitzke]

Never mind

Form_Current seems to be doing the trick...