Access export to pdf based on check boxes

Hello,
I'll try to explain this the best I can, I currently don't have any code for it. I've been looking all over the place trying to find some kind of hint of it. I know it can be done

I have a database that pulls reports of technicians warehouse.
I have a form [Division_PB] that has a subform named [Tech_Print_Selection subform]
this subform displays 5 fields from the query [Tech_Print_Selection] the name of the table this is attached to is [Cycle_Count_Techs]
the fields are as follows in the query/subform: Technician, Tech#, WHS, CurrentDiv and Selection.

I have a macro called [Price_Book_Bin1_M] that runs the report.
The name of the report being run is [Price_Book_Bin1_F]

on the subform I have made it so I can drop down a box and sort based on the field CurrentDiv.
what I want to be able to do is the following

select a number of checkboxes and click a command button to export the selected warehouses to their own separte pdf files.
so checkbox 5 items, produces 5 pdf files. after competed it must remove the check from the boxes
I want the file saved with the name of 3 of the fields in the subform (CurrentDiv, Technician and WHS) in that order.



Tables
Cycle_Count_Techs

Queries
Tech_Print_Selection

Forms
Division_PB - SubForm = Tech_Print_Selection subform

Report
Price_Book_Bin1_F

Macro
Price_Book_Bin1_M



I was looking at a for loop to do this, but haven't had any luck finding what i'm looking for...
I think I've stated everything I need to produce this. hopefully you guys can help.


Thanks!!

I would drop the checkbox method and use an easier one...

make a table tPicked to hold the selected warehouses.
in a form put 2 listboxes,
lstAvail that shows all warehouses to pick from
lstPicked that shows the tPicked table to hold what the user picks to report on.

on lstAvail dbl-click, run an append query to add the list item to tPicked

the your report, Price_Book_Bin1_F, will use a query that looks at the form lstPicked warehouse selected:
select * from table where [warehouse]=forms!myForm!lstPicked

cycle thru the picked list and export the reports

Please Login or Register  to view this content.

That's a cool idea ranman256, I'll try that out!