Does't one of the sample databases in Access contain this functionality??
Larry Linson wrote:[color=blue]
> Most anything is possible, with some well-thought-out design and some
> experience using Access' VBA code. I wouldn't start out trying to
> modify a Switchboard created with the Switchboard Manager, however.
> But you can certainly create Switchboards that are based on Tables,
> and other factors.
> Larry Linson
> Microsoft Access MVP
>
> <ghadley_00@yahoo.com> wrote in message
> news:1140036297.323670.79690@f14g2000cwb.googlegro ups.com...[color=green]
>> Hi,
>>
>> Is there a way to have the labels in a MS access database switchboard
>> dynamically generated based on values in a table? I have a table of
>> items (let's call it table Main) , each of which is assigned to a
>> category. The list of categories is stored in a separate linked table
>> (let's call it Categories). The Categories table consists of entries
>> that have an ID number and a name.
>>
>> I have made queries of the Main table where I make the search
>> criteria the ID number for the category of interest.
>>
>> I then made a report for each of these queries.
>>
>> I would like to make a switchboard that has links to the reports I
>> have made (one for each category, which is a fixed number), but I
>> would like the text labels for each of the options to be the
>> description listed for each entry in the Categories table.
>>
>> In essence, is it possible to create a switchboard which can
>> dynamically generate its text labels based on fields in a table?
>>
>> Any help that could be provided would be greatly appreciated.
>>
>> Best wishes,
>>
>> George Hadley
>>
ghadley_00@yahoo.com[/color][/color]
--
regards,
Br@dley
