Check box Crosstab Query

[douglasjoh]

Hi,

I am using a crosstab query to present an Master Production Schedule (MPS).

I would like to be able to add check boxes into my form that would allow users to filter the data by Stage. There is 6 stages in the data.

How do I go about this as I am a beginner at excel.

Should I use VBA or try and use a IIF statement in the criteria of my Query?

If you could advise or point me in the right direction that would be brilliant.

Thanks.

 

[ranman256]

You wouldn't use a Crosstab to filter data. The Crosstab is the end result,
not a tool to enter data,then undo the Crosstab.

To filter ,you'd use a form with combo boxes.
the user picks items in the boxes,then apply the filter.

 

[douglasjoh]

You wouldn't use a Crosstab to filter data. The Crosstab is the end result,
not a tool to enter data,then undo the Crosstab.

To filter ,you'd use a form with combo boxes.
the user picks items in the boxes,then apply the filter.

Hi Ranman,

Maybe I didn't explain my self well enough.

Using a form with combo boxes/check boxes to filter the crosstab query is what I would like to be able to do.

Any ideas on how I do this? Such as guides?