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

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.



"(E-Mail Removed)" wrote:

> 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
>
>

On Feb 21, 4:14 pm, Eric Blitzer
<EricBlit...@discussions.microsoft.com> wrote:
> I assume you are using subforms in each tab. If not I would recommend you
> to. Base thesourceof each subform on a query with that state as the
> criteria.
>
> "car30...@gmail.com" wrote:
> > I have created atablewhich contains information regarding clients I
> > do business with. I currently do business with clients from five
> > states. I wanted tocreateaformwithmultipletabs. Each tab will
> > represent a state (total of 5tabs). 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
> > typeformdegrade the performance of my database? I plan on created a
> > few more of these types of forms.
>
> > Thanks

I would like to add new records to my table? I don't know if basing
my subform on a query will accomplish this.

(E-Mail Removed) wrote:
> On Feb 21, 4:14 pm, Eric Blitzer
> <EricBlit...@discussions.microsoft.com> wrote:
>> I assume you are using subforms in each tab. If not I would recommend you
>> to. Base thesourceof each subform on a query with that state as the
>> criteria.
>>
>> "car30...@gmail.com" wrote:
>>> I have created atablewhich contains information regarding clients I
>>> do business with. I currently do business with clients from five
>>> states. I wanted tocreateaformwithmultipletabs. Each tab will
>>> represent a state (total of 5tabs). 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
>>> typeformdegrade the performance of my database? I plan on created a
>>> few more of these types of forms.
>>> Thanks
>
> I would like to add new records to my table? I don't know if basing
> my subform on a query will accomplish this.
>

I would recommend using one subform, and filter it using a combo box
selection (selectState maybe).

What happens when you need to add/delete a customer from a state?
Add/delete another TAB and subform and query?

The comboBox source should select states for all active customers.


hth,
Andy