With this syntax:
Private Sub cboGrade_Click(Cancel As Integer)
If Me!cboRank = "AMN" Or Me!cboRank = "AB" Or Me!cboRank = "A1C" Or Me!cboRank = "SRA" Or Me!cboRank = "SSGT" Or _
Me!cboRank = "TSGT" Or Me!cboRank = "MSGT" Or Me!cboRank = "SMSGT" Or Me!cboRank = "CMSGT" Then
Me!cboOfficerPAFSC.Visible = False
Me!cboOfficerPAFSCPrefix.Visible = False
Me!cboOfficerPAFSCSuffix.Visible = False
End Sub
i don't get any errors, but on the other hand it doesn't work
am i doing something wrong? basically its saying that if the rank is equal to one of 9 ranks, then the 3 cbo's listed should not show.
Private Sub cboGrade_Click(Cancel As Integer)
If Me!cboRank = "AMN" Or Me!cboRank = "AB" Or Me!cboRank = "A1C" Or Me!cboRank = "SRA" Or Me!cboRank = "SSGT" Or _
Me!cboRank = "TSGT" Or Me!cboRank = "MSGT" Or Me!cboRank = "SMSGT" Or Me!cboRank = "CMSGT" Then
Me!cboOfficerPAFSC.Visible = False
Me!cboOfficerPAFSCPrefix.Visible = False
Me!cboOfficerPAFSCSuffix.Visible = False
End Sub
i don't get any errors, but on the other hand it doesn't work

am i doing something wrong? basically its saying that if the rank is equal to one of 9 ranks, then the 3 cbo's listed should not show.