Tab Control with "filtered" Crosstable Query

[filo65]

Hi,

the title like my problem is a little bit messy, but maybe some of you can give me the right hint.

I have a table with information that I display in a Crosstab query. To give a small appeal to the output and to make it a little bit more readable I created a form with a Tab Ctrl. Every page as a name that should filter the CrossTab query (the page's caption should be the filter!) . Difficult to explain easy to see; I attach an example hoping in you guys.

TIA

filo65

 

[Dylan]

Filo65,
I can't remember how to remove record selector.
But here is the solution to the filtering on the form that you asked for.
Cheers,
Dylan.

 

[filo65]

Hi Dylan,

thank you. I'm getting older! I should have thought by myself to this solution!!

I guess anyway, it becomes a little bit tricky when willing to keep a single CrossTab query (I entered two groups, but imagine having dozens). One query filtered trough the page's name/caption would keep my database light and flexible.


filo65