Need Help with Select Case "not" equal to N/A message box

[GinaFlan]

Select Case Not Me.TxtActualBenchmark
Case "N/A"
Select Case Me.txtBenchmarks


Case "At least one program every 6 months"
Select Case Me.ComboMonth
Case "January", "February", "March", "April", "May", "July", "August", "September", "October", "November"
MsgBox "Please put N/A", vbOKCancel
Case "June", "December"
'do nothing
End Select
End Select
End Select

[ranman256]

Your select is jacked...you have too many selects in it...
and you can always use CASE ELSE, or not "n/a"

Select Case TxtActualBenchmark
    Case "N/A"
    
    Case "At least one program every 6 months"
            Select Case Me.ComboMonth
                Case "January", "February", "March", "April", "May", "July", "August", "September", "October", "November"
                     MsgBox "Please put N/A", vbOKCancel
                Case "June", "December"
                     'do nothing
              End Select
              
    Case Else    'or   NOT "N/A"
       'SOMETHIN
End Select

[GinaFlan]

Ok Thank you