Update check box based on value in another

[ste4en]

I have a row of checkboxes to show work stages completed. If I check box stage4 - I want stage1, stage2 and stage3 to be checked. Below is how I was trying to get Stage3 to check itself. It is on the AfterUpdate. It does not work. Please show me how. Thanks; Steve

Private Sub Stage4_AfterUpdate()
If Stage4 = -1 Then
Stage3 = -1
Else
Stage3 = 0
End If

End Sub

 

[randy700]

Private Sub Stage4_AfterUpdate()
    Me.Stage3 = Me.Stage4
End Sub

Randy

 

[ste4en]

that was easy - thanks.