Automatic Field Input on Several Reports

[Martin Hopkins]

Hello,

I currently have numerous reports that are printed by several personnel as
and when they required them. The reports are structured as company policy
and prompt the user to input several details eg who from, telephone numer,
file ref, who to etc.

This works well for a single report, but I have to produxce 7 reports at the
end of each month, and currently I have to input the above requirements evey
time for each report. Rather than build new reports with my datails already
in the report, can I run a macro? that sets the values for Who From,
Telphone etc for all the reports within the macro?

Any help greatly appriciated.

Martin Hopkins

 

[Steve Schapel]

Martin,

Forget the Parameter Query idea. On a form, put unbound controls
(probably textboxes or comboboxes) for you or the other users to enter
the criteria. Then, in the Criteria of the queries that the reports are
based on, in the place of the existing parameter prompts, refer to the
form controls using syntax such as ...
[Forms]![NameOfForm]![NameOfControl]