I have a table of categories. Each category then has many records assigned to it. In my form, I have the Categories as a parent form, then a continuous subform with all the records, tied together by Category ID. So, when the user goes to the next category, it will only show that cateogry's records, and any new records are automatically assigned to that category.

This all works fine.



But, what I would like to have is, in the header of the Category form, either a tab for each category, or at lest some sort of marquee that always has the current category in the center, then the two or three categories before and after listed to the left and right.

I can probably do the second by using the Current event and Me.RecordSetClone to get the category names for the previous and next few categories and assigning them to existing controls, but I was hoping that I could somehow use tabs to list all categories available.

Does anyone have any recommendations for the best approach on this?