Health Care - CAS

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

Guest

I am trying to make a Carotid Stenting access workbook for internal data.

I need to open certain combo boxes based on Yes or No answers, that i think
I have figured out. My issue is that if cbo_risk= yes my risk_outcomes combo
box opens, not based on a single response of "Clinically Significant Cardiac
Disease" will determine if another combo box opens up, which would be
cbo_heart_disease.

Below is what I have written so far.

'Show list of symptomatic
Private Sub cbo_sympto_beforeUpdate(Cancel As Integer)
If cbo_sympto = "Yes" Then
cbo_symp_out.Visible = True
Else
cbo_symp_out.Visible = False

End If
End Sub

Private Sub cbo_risk_BeforeUpdate(Cancel As Integer)
If cbo_risk = "Yes" Then
cbo_risk_out.Visible = True
Else
cbo_risk_out.Visible = False
End If
End Sub

Private Sub cbo_risk_out_BeforeUpdate(Cancel As Integer)
If cbo_risk = "Yes" And cbo_risk_out = "Clinically Significant Cardiac
Disease" Then
cbo_heart_disease.Visible = True
Else
cbo_heart_disease.Visible = False
End If
End Sub
 
Hello Andy
Couple of points
Try:
cbo_symp_out.Visible = (cbo_sympto = "Yes")
You can also AND the condition eg
cbo_symp_out.Visible = (cbo_sympto = "Yes") AND (etc)
I generally use the Change or AfterUpdate event
Other than that...
HTH
Terry
 
Back
Top