Reports based on Combo Boxes

[Guest]

Need to create a form that allows users to generate Excel Reports based on
combo boxes.

IE, I want to generate a report based on a part numberin a combo, or a
buyer's name, or destination. Is this possible in Excel?

 

[fredg]

Need to create a form that allows users to generate Excel Reports based on
combo boxes.

IE, I want to generate a report based on a part numberin a combo, or a
buyer's name, or destination. Is this possible in Excel?

Probably, but why don't you post this in an Excel newsgroup?

You have posted this message to the wrong news group.
The access in this newsgroup's title refers to Microsoft Access, a
database product.

 

[Guest]

This is an Access question. I am working with a access database form that has
mult. text boxes, combo boxes etc. on it. As of now, you can select a name
from a combo box and another form will activate that lists all records for
the item in the combo box. I would like to have the ability to generate an
excel sheet for the combo box items instead of generating records. I.e.,
select a part number, click the command button, and an excel sheet generates.

I know you can do this if you create a seperate query and macro for each
item then attach it to an individual command button, but this is labor
intensive and will require work everytime a new part etc. is created.

Thanks, Brian