Change status when a particular check box is selected 1

[Shusha]

Hi there,

I love this forum as one learns a lot without leaving ** the seat. Thanks so much for all of you who help so selflessly..
I have a question which might be easy, but requires a wee bit of explaining.
I have three check boxes, which are the various statuses a client can go through.
IF the user checks Feedback, i would like the status field to get changed to "Feedback Given".
or
If the user checks "Ineligible", the status box changes to " Client Ineligible"
or
If the user checks "Started program", the status gets changed to "Active"..

and the list goes on and on.. i have about 10 diff. status that gets checke depending on which stage the client is at. The data input person forgets to change the status tab ( a drop down one) when she changes the status ( the check box one).. resulting in confusion.. I wld like to force them to change the status box when they activate any of the checkboxes.


Your valuable input is appreciated. I thank u in advance..

usha

 

[jfischer]

I'd suggest writing a procedure that checks all of the checkboxes and sets the status box accordingly. For example:

Private Sub CheckStatus()
  If Me!chkFeedback = True Then
    Me!cboStatus = "Feedback Given"
  ElseIf Me!chkIneligible = True Then
    Me!cboStatus = "Ineligible"
  ElseIf Me!chkStarted = True Then
    Me!cboStatus = "Active"
  Else
    Me!cboStatus = ""
  End If
End Sub

Then, invoke this procedure for the OnClick event of each checkbox. For example:

Private Sub chkFeedback_Click()
  CheckStatus
End Sub

 

[Shusha]

Thanks Jfischer..
Ur help in this matter is greatly appreciated. it worked fine and now i can do a few nifty things.. thanks so much.. for ur valuable advise..
usha