Checkbox

[cathyt]

I have an existing database for reviews. There are 3 columns with
checkboxes; SD Comply, CV Comply, Approve.

What we're hoping to do is have the Approve checkbox automatically be
checked based on the first and second boxes being checked, like this: (so if
SD Comply is checked and CV Comply is NOT checked, then Approve is NOT
checked)

SD Comply CV Comply Approve
Y Y Y
Y N N
N Y N

I found on this forum how to do it for 2 columns (if SD Comply is checked,
then Approve is checked or vice versa), but can it be done adding another
variable? I am using Access 2003. Thanks for your time!

 

[Wayne-I-M]

Private Sub CV_Comply_AfterUpdate()
If Me.CV_Comply = -1 And Me.SD_Comply = -1 Then
Me.Approve = -1
Else
Me.Approve = 0
End If
End Sub

Private Sub SD_Comply_AfterUpdate()
If Me.CV_Comply = -1 And Me.SD_Comply = -1 Then
Me.Approve = -1
Else
Me.Approve = 0
End If
End Sub


Note - I have changed your control names by adding "_" (underscore)

 

[cathyt]

Thank you very much, Wayne! Works great!

Private Sub CV_Comply_AfterUpdate()
If Me.CV_Comply = -1 And Me.SD_Comply = -1 Then
Me.Approve = -1
Else
Me.Approve = 0
End If
End Sub

Private Sub SD_Comply_AfterUpdate()
If Me.CV_Comply = -1 And Me.SD_Comply = -1 Then
Me.Approve = -1
Else
Me.Approve = 0
End If
End Sub


Note - I have changed your control names by adding "_" (underscore)