Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

form validation 1

Status
Not open for further replies.

webdevop

MIS
Sep 18, 2003
11
US
I have a combo box cbolist, I want the user to not be able to have a blank entry otherwise it runs a report on all entries which takes considerable time.
Any ideas ?

Thanks ....
 
Wherever you have the code to open the report, try:

If IsNull(Me![cbolist]) Then
MsgBox("You must choose an option to view report")
Else
' Whatever you do to open report
End If

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top