Help with form which selects report

[ed333]

For my firm's billing system, there are 2 different bill formats. I have created a report for each of them. From the switchboard, I need to user to be able to select "Print by Client", "Print by File", or "Print by Attorney." The bill format is stored in the client's record in tblClients. I created a form for "Print by Client" which works fine.
My question is this: Do I need to create 3 separate queries, since the parameters will change based on client, file, or attorney? Does this mean that I need 6 reports, or is there a way to dynamically select the report's recordset during execution?
Any help will be appreciated!

ed

 

[dcx693]

Base the report's recordsource on a query and base the query on the user's selection from switchboard and the bill format stored in tblClients.