If then statement (I think)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have five checkboxes: chkRes chkGar chkPlat chkAdvert chkFlow
If any of the above boxes are checked on the data entry from, I would like
to have an "X" automatically filled into another field named txtCount.
However, if none of the above boxes are checked, I would like the field
txtCount to be empty.

TIA
 
Trap the AfterUpdate event of each of your check boxes, and call code this
sub

Private Sub checkCount
If chkRes Or chkGar Or chkPlat Or chkAdvert Or chkFlow Then
txtCoun t = "X"
Else
txtCount = ""
End If
End Sub

HTH, Graeme.
 
Back
Top