It Then Coding (Acess 2003 SP2)

Topic

New Reply

I need some coding help in a form.

I have 3 Yes/No boxes:

If Box01 is marked YES and Box02 is kept at NO, them mark Box03 as Yes.

If Box01 is currently YES and Box03 is currently YES, but Box02 is UPDATED to YES, then UPDATE Box03 to NO.

If Box01 is updated to NO, then updated Box02 AND Box03 to NO

Thanks

Reply | Quote

Replies

The following code matches your requirements as posted:

Private Sub Box01_AfterUpdate()
If Me.Box01 = False Then
Me.Box02 = False
Me.Box03 = False
ElseIf Me.Box02 = False Then
Me.Box03 = True
End If
End Sub

Private Sub Box02_AfterUpdate()
If Me.Box01 = True And Me.Box02 = True Then
Me.Box03 = False
End If
End Sub

Reply | Quote

Thank you that was great. short and simple.

Reply | Quote