Click box's for reports

[m17347047711116]

Have many reports that users print regularly some multiple at a time sometimes one at a time.

Would like to set up check box's on my form ,when the person clicks the reports that they want to print and then hit the PRINT button the selected reports will print?

Any help appreciated
thank you

 

[The_Doc_Man]

Not too bad, but probably will require some VBA code.

Make each checkbox on your form. (These checkboxes can be unbound with regard to any underlying data.)

Make a command button that prints a report. (The command button wizard supports this option, I think.) Let it build the skeleton of the button-click event for you.

Then design the form and click the code icon so you can muck the code.

The wizard will have built something that looks like

DoCmd.OpenReport, "report-name", acNormal

So change the code to look like

If [CheckBox1] then

DoCmd.OpenReport "report-name-1", acNormal

end if

if [CheckBox2] then

DoCmd.OpenReport "report-name-2", acNormal

end if

etc. etc. etc.

I used names like CheckBox1 and report-name-1 but you will have to supply the correct names for these items. When done editing, recompile and save the code. Save the form. You are done. Start testing.