I am coming back to access after a while. Can any one tell me how to identify which macro outputs to which report. How do I find this out? Is there a way to check this for all reports on the access 2003. The names in this db are not very intuitive. thanks
the report's record source tells you whether it is sourced on a query or table by name.
whether or not the opening of the report is triggered by a command (vb code somewhere), or by a stand alone command button....and whether or not via a macro is very situational. There is no way someone in a forum can answer that...you will have to audit your application...
figure out what triggers the report open and then look at the code.