Cannot use the crosstab of a non-fixed column as a subquery

M

Melanie O

I have a chart on a form that displays data for each group by day, filtered
by a combo box at the top. I would like to open a second form that displays
data in a chart based on the selection of the combo box on the first form.
When I use the criteria "ID = ID" in VBA, I receive the "Cannot use the
crosstab of a non-fixed column as a subquery" error. Is there any way to
filter data on a chart based on a previous chart's data?

Thanks in advance,
Melanie
 
Top