Thedon123
Registered User.
- Local time
- Today, 08:46
- Joined
- Sep 11, 2002
- Messages
- 98
I have a problem. a user selects a values in an cascading combo.
when he reaches the last one he clicks on select. this gives him an msg box telling the code of the last combo.
what i am trying to do is to give him an error if there is nothing in the last combo. i.e it is blank which means the msgbox cannot display any code.
i have used the code below. the problem is that the code doesnt recognise the "" as a null value, so how do make it recognise a null value.
Private Sub SelectSRO_Click()
If Me!SearchOperations.Value = "" Then
MsgBox "There is no value"
Else
MsgBox "Please enter or select " + "'" + Me!SearchOperations.Value
End If
DoCmd.Close acForm, "SRO_Search_Add"
End Sub
when he reaches the last one he clicks on select. this gives him an msg box telling the code of the last combo.
what i am trying to do is to give him an error if there is nothing in the last combo. i.e it is blank which means the msgbox cannot display any code.
i have used the code below. the problem is that the code doesnt recognise the "" as a null value, so how do make it recognise a null value.
Private Sub SelectSRO_Click()
If Me!SearchOperations.Value = "" Then
MsgBox "There is no value"
Else
MsgBox "Please enter or select " + "'" + Me!SearchOperations.Value
End If
DoCmd.Close acForm, "SRO_Search_Add"
End Sub