Printing many docs for a chosen period.

[Perfac]

I set up a form to print salary slips for a month. Table t01Salary keeps all data for all the years. q01Salary is a query with some added fields. f01Salary is the form which r01Salaryslip print the slip. I manage to do one at a time. I would like to choose a month and click one print command that print 20 salary slips if there is 20 slips needed to be printed. Thank you.

[aytee111]

The month to choose will be a field on the form, maybe a combobox depending on your needs. Then when you open the report use a filter,
such as "Month(SalaryDate)=" & Me!SelectMonth

[Perfac]

Thanks my new friend. In my sales invoice table on the form there is a print button. Clicking on the print button in design mode in the Macro I have as WHERE CONDITION [InvSalID]=Forms![f02InvSales]!InvSalID which print the one. I am able to filter a query to find a certain months invoices in that query. I feel dumb but surely there is something small I miss. I want to click print once then it should print each document found in the query?

[aytee111]

Use the filter instead of the where. Then make sure that the value used in the filter matches the query for your report - the name must be on the query (InvSalID) and the value must be present.

Try it manually first - create a query based on the record source for your report, then enter the value on your form into the criteria of the query, make sure that it works as expected.