Expert Gudance for Form Struture Please

[buckwheat]

Hi,

I'm still plugging away at restructuring an inherited database. There is a report menu that contains several reports, each report opens a form and each form searches the respective report by start and end dates. Each form also has a "print" and "preview" button.



What I would like to do is put all of these report options on one form with "one" cmd button to do the repetitive commands such as start and end dates, print, and preview. Is this possible?? What is throwing me off is how to construct the various queries to run each report if only one print and preview button is available.

[pbaldy]

I often use a single criteria form, and pass the name of the report to be opened in OpenArgs. The criteria form uses that to open the appropriate report.

[buckwheat]

Thanks, can you be a little more specific please regarding the OpenArgs?

[pbaldy]

Check it out in VBA help and post back if you have trouble applying it.