If no data found-return message in form

[trialerror]

I have 2 combo boxes on my form. Based on what I select in the first one, the second one is populated using an underlying query. But what if there is nothing matching the selection in the first-I would like to have a message displaying like "No data found" etc.
Thanks for all your help.

 

[ZOR]

Use the controls Listcount property to count items in the combo after you have populated it.

 

[trialerror]

What do I do with it- which event do I link it with ? Thanks

 

[Remou]

Hi
How about using the On Change event of combo box #1?
If ComboBox2.Listcount=0 Then
MsgBox "No data"
End if

 

[trialerror]

Great-this works but does not "refesh " itself, if I go back in the form and it already has the selections in the first combo box, it does not display the message again unless I click the first combo box again. Thanks

 

[Remou]

Well then the form current event, maybe?

 

[ZOR]

If your code is such that you say Combo2.Requery in the Combo1.Click event, you can then follow with the code Remou gave. I am presuming you are clicking Combo1 to fill Combo2?

 

[trialerror]

Thanks-will give it a try.