Tabbed control

[RonnieODIN]

Hi,

I am trying to make a db where I need to show a list in different states. I am trying to do this by inserting the list into a tabbed control. Then I would like to make the list refer to each tab and only show the posts matching the tabs. Is this possible to do without having many tables showing the same thing resulting in equally many forms?

Any ideas will be appreciated.

-Ronnie

 

[John Big Booty]

Welcome to the forum.

Me.YourTabControlName

Will return a numeric value that represents the Tab that currently has focus. Remember that the tabs are numbered from Zero up, so Tab number one will return zero, tab number two will return one, and so on.

You could use this information in conjunction with the On Change event of the tab control to filter the Record Source for your Form, to show only the records relevant to the current tab.