record count() simple doubt

[proggy]

I have a report to be shown and I want a message box to pop up and say no records when there are no records in the underlying query of the report.. can anyone help me with this..
If I have to use rst.open......() then where i have to write this part of code..
thanks,

 

[cmmrfrds]

There is an OnNoData event on the report. Put your msgbox code in this event.

In the OnOpen event you can equate the rst.open to the recordsource. Instead of the open method use the execute method of the rst object. You can also use a command object in ADO instead of the recordset object. Check out the syntax in help.

me.recordsource = rst.execute