Access database with one form, multiple tabs, one table source

[car30000]

I have created a table which contains information regarding clients I
do business with. I currently do business with clients from five
states. I wanted to create a form with multiple tabs. Each tab will
represent a state (total of 5 tabs). If I select a tab I would like
to see only the records of those clients that belong to that state.
Anyone have suggestions on how to approach this? Will creating this
type form degrade the performance of my database? I plan on created a
few more of these types of forms.

Thanks

 

[Eric Blitzer]

I assume you are using subforms in each tab. If not I would recommend you
to. Base the source of each subform on a query with that state as the
criteria.