generate a report/form by category

[Sam_Bur]

Hi everyone,

I am tring to generate a report or form, its generated by a combo box, which list all the categories of the products, when the category is clicked on it will generate the report or form showing all the products for that particular category. Can anyone point me in the right direction? Any help would be appreciated.

 

[Dennisk]

Hi Sam,
Your report should have a query as its recordsource.
The query can then use the value on the combo box as the filter criteria.
You would refer to the combobox as Forms!YourFormName!YourComboBoxName

 

[Sam_Bur]

Thank you, will give that a try, and let you know if i succeed

Sam

 

[Sam_Bur]

Hi Dennisk,

Thanks again that worked fine, no problemos what so ever!!

Cheers

Sam