cross tab report variables

[jasn_78]

hey guys i have a cross tab report that atm i only have being filtered by a listbox from one table basically what i need to do is be able to filter the same report by 1 or more tables i.e there are 4 tables to choose from which are department, subgroup, group and supplier which means i want to be able to choose a department as well as a group or any other choices together to run this report but not sure how i would go about it.

I am really just after how i should not exact code (find it best way for me to learn.)

If some1 could help this would be great.

Thanks in advance

 

[ted.martin]

Maybe your need a Table selection list box on a previous form. Once selected, use that value to set the Control Source on the current list box. From that selection, you may either need to use a variable to use in the Crosstab which would then have to be run in SQL unless the following is possible for you

Me.tag = listbox.value

In the crosstab filter criteria would be forms!YourFormName.tag

 

[jasn_78]

thanks ted but one list box isnt based on the results of the previous one it is just multiple filters to gain a list of item records