run a report but not show it, when form load

[smahdih]

hi

how can i run a report or query and check it for record but not show report or query and i want when a form load, check the report
like:

on load event form:
if count(report) >0 then
msgbox " you have record"
end if




how can i do this?

[pbaldy]

As posted elsewhere, you can use a DCount() function.

[smahdih]

As posted elsewhere, you can use a DCount() function.

sorry for duplicate post,

i use dcount() function and fiix it.

sepasgozar (means tnx alot)

[pbaldy]

Happy to help.