blackie42
10-17-2007, 05:20 AM
I have set up a form with a combo box and 3 option buttons
depending on whats selected from combo & which optionbutton is selected it goes off and executes that bit of the code.
Tryna get it so if combo is selected but no optionbutton then it goes no further (well puts out a message 'select tier') but it seems to skip and go to the end of the code where there is a message that input was succesful.
think I might have the syntax wrong?
If Form.cmb = "" Then
MsgBox "Select Portfolio"
Exit Sub
End If
If Form.OptT1 = "" And Form.OptT2 = "" And Form.OptT3 = "" Then
MsgBox "select tier"
Exit Sub
End If
any ideas what I'm missing?
thanks
depending on whats selected from combo & which optionbutton is selected it goes off and executes that bit of the code.
Tryna get it so if combo is selected but no optionbutton then it goes no further (well puts out a message 'select tier') but it seems to skip and go to the end of the code where there is a message that input was succesful.
think I might have the syntax wrong?
If Form.cmb = "" Then
MsgBox "Select Portfolio"
Exit Sub
End If
If Form.OptT1 = "" And Form.OptT2 = "" And Form.OptT3 = "" Then
MsgBox "select tier"
Exit Sub
End If
any ideas what I'm missing?
thanks