filtering tabbed control

[CK1]

Hi

I'd welcome advice on tabs please, I've never used them before but I can see
how they might be useful.

I have a finite database of 600 or so CurriculumStatements in 25
CurriculumAreas. FormStatements has all 600 expressed in datasheet view, but
I would like to subdivide this datasheet into separate tabs for each
CurriculumArea.

where or how do I go about the filtering process?

Thanks for your help
regards
CK

 

[ErezM via AccessMonster.com]

hi
tabs are indeed very useful presentation format, but i think the case you are
dealing is not the perfect example: if you are really going to have ~25 tabs
with a subform on each (datasheet or continuous) thats a heavy form (it's
really 25 forms plus the hosting form)

i ran across a similar situation, where the client insisted of having it's
20+ users each with a tab with it's name on it at the top of the screen, and
below were tasks recorded for each user
so, put a tab control at the form's header secion, (with all 25 pages) - but
size it to just show the tabs, without the actual page under it.

set each page in the tab control to caption=the Curriculum Area, Tag=the
Curriculum Area ID (if there is something like that)

then set the form to Continuous and recordsource to CurriculumStatements.
then use the tab control's OnChange event to filter the form's recordset to
the right sub-group:

Me.Filter = "CurriculumArea=" & TabCtl1.Pages(TabCtl1).Tag
Me.FilterOn = True

which means: show only records that match the Tag value of the
active/selected page in the tab-control

good luck
Erez