combo-query!

shivalee

Registered User.
Local time
Tomorrow, 04:12
Joined
Feb 4, 2005
Messages
13
i have a form which has 9 combo boxes. each combo box value when selected inturn runs a parameter query. i need to write a code wherein if zero (0) rows are returned it should not show me an empty sheet, else show a message saying, no rows found for this.
any suggestions,...please help!
shivaleee
 
Might not be exact, but are you after somthing like this?

Sub combo1_BeforeUpdate()
combo2.rowSource = "SELECT ......"
If combo2.ColumnCount = 0 then
msgbox "Now Rows Found For This"
Else
....
End if
End Sub

If not, I need a better description.

Todd
 

Users who are viewing this thread

Back
Top Bottom