Export Form Criteria to Excel

[acarterczyz]

Hey guys,

I have a form that has a ton of checkboxes.

1. Select Product (combobox) or All Products (CheckBox)

2. Product Type (3 different checkboxes)

3. Includes (10 checkboxes)

What I need is these checkboxes to filter the selected data from my Details table and export it to a new excel file that the user chooses where to save.

I'm clueless when it comes to VBA, but I'm willing to learn. Is there any easy way to tackle this? If you need more info, please let me know.

 

[acarterczyz]

Anyone know how to do this? Any help would be MUCH appreciated.