[MS_AccessPros] Value of Combo Box

 

I tried writing my first bit of code without help and went down if flames.

I have a form that the user will select a value from a Combo box and then press a button to view the next form, sorted by the combo box.

As the first part of the code I tried to use...

Private Sub Command12_Click()
If [cboSeason] = Null Then
MsgBox "Season field must be filled"
End If

End Sub

The "Null" does not work. If I put a value in there(If [cboSeason] = 1) and then set the combo box to that value it works fine.

What is the value of an unfilled combo box? I figured it would be Null. An empty combo box = Null comes up False.

I am trying to eliminate the Access error boxes when a query is run without the combo boxes being full.

Thanks for your help.
Bill
MN

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___