Display one record per tab

[Mindzeye]

I have a table with only ten records, this will not change. I would like to create tabs like and index showing one record per tab. Is there an easy way of doing this

 

[Pat Hartman]

Whether you click on a tab or on the "next" button of the navigation bar, the user needs a single keystroke to move to the next record.

The simplest way to do this to make the tab control look like it is showing a different record is to use a subform that sits on the main form so it shows on each tab page. When you click on the tab page, change the filter in the subform to show the desired record.

 

[Mindzeye]

Pat,
Thank you for your reply, my goal with the tabs is to be able to show all of the topics at one time and allow the user to quickly go to that topic. I dont know how to associate a tab to a record so it will display all of its contents.

 

[Pat Hartman]

Since you only have 10 records, you know the PK of each one. The click event of the tab will be used to move the subform to that specific record identified by its PK.

I would personally not design my interface this way. You say the table has 10 records and this will never change. Well, I have a bridge for sale. It is this type of data based hard-coded format that makes Excel so difficult to change. In a relational database, we do things a little differently. Our mantra is, if you have more than 1, you have many and so you design for many rather than 10, or 3, or 2897.

I would use a listbox to show the ten items. Then in the BeforeUpdate event of the listbox, I would requery the subform that shows all the other data fields.

This is a sample of what I'm talking about. The listbox on the left controls what shows in the form to the right. With this type of design, I don't need to make any changes if the users add more items to the listbox. This form also has several other tabs with other information.

 

[Mindzeye]

Thanks Pat I like the idea and think I can make it work the way I want to use it