How to automatically turn on a checkbox

  • Thread starter Thread starter Darrell Childress
  • Start date Start date
D

Darrell Childress

On my form, there are 2 fields - one named Process and the other named
ShipReady. The Process field is a combo box with 8 different choices.
What I would like to do is create something that if a user chooses "P",
"I", or "X" from the combo box, then the ShipReady field will
automatically become checked; otherwise, it remains unchecked.
Thanks,
Darrell
 
Private Sub Process_BeforeUpdate(Cancel As Integer)
If Process = "P" or Process = "I" or Process= "X" Then
ShipReady= True
Else
ShipReady = False
End If
End Sub



Not tested, but that should work. I'd also make the check box locked so
users can't override it.
 
Back
Top