help : report & combo box

[mifee]

Hi

i have a table that contains product code for each item i have in store.

now i want to generate report by each product code and in the form i planning to put combo box.when i choose produxct code from combo box ,there show me the reports.

thanks for helping

noob :banghead:

 

[Trevor G]

Welcome to the Forum,

Create your report from a query and then on a form place in a combo box and name it something like cboProduct then you would open the query in design view. Select the criteria of the product and then use the Build Wizard to use the form and combo box as the filter, then just add a command button onto the form which runs the Report.