Test Query for Records

[FrankPV]

Hello!
I have a form that displays a msgbox if a query has any records. The query executes when the user exits the combo box. If there are any records in the query I want to display a msgbox. If the query is empty I want to skip the msgbox. I don't know the proper VBA code to test whether the resulting query has any records. Any help would be appreciated. Thank you.

 

[Maquis]

Check out the DCount function. Sounds like what you need. Maq
<insert witty signature here>

 

[FrankPV]

Thank you. This is exactly what I was looking for and it works fine.

Frank