check report for record in on load event form

[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]

You could use a DCount() function against the query or table.