Printing different forms based on selection

[marina9]

I have a database that tracks work orders. There are 5 different types of work orders, each displayed on a separate form. For example, for a Radar work order there is frmRadar form, for a Video work order there is frmVideo form, etc.

There is an additional form that shows a listing of all work orders in the database (frmListing). In the frmListing form the user can select a combination of different criteria (work order type, client, data range, etc.) to narrow the recordset.

I am trying to create a button that will "batch" print all the forms from the selection. For example, if in frmListing I want to print all forms dealing with client "X" and client "X" has 2 Radar work orders and 4 Video work orders, how do I print only those 6 work orders?

Any help would be greatly appreciated. Thanks!!!

 

[Trendsetter]

In the query that will populate the report use criteria in the client column that will be used to identify the client selected on the working form - in the criteria column put:

Forms!frmselector!ClientID

which will be the location of the data for the client!

 

[marina9]

Thanks for you message Trendsetter! What I am trying to do though is not create a report but rather print the form where the user enters data. I could create different reports but since each type of form contain different fields I would need to create 5 different reports. How would I loop through the recordset and print either the different forms or different reports? Thanks!!!