Is it possible to change the limit on the number of items
allowed on any switchboard. The limit I have come
across is 8 and I need about a dozen items on one.
If it is possible, how do I do that?
The only limit on number of selections on a Switchboard is that imposed by
the Switchboard Manager. I don't use the Switchboard Manager, because I
consider it a complex solution to a simple problem... with a table and (not
well documented) limits and quirks.
I note that Karl gave you a solution that involved manual modification of
the output of the Switchboard Manager, an approach that I definitely do not
recommend. Unless you are knowledgeable about the internals and operation of
the Switchboard Manager, your changes are likely to be lost, or broken, if
you again use the Switchboard Manager attempting to maintain your
Switchboard (perhaps not even the same Form that you modified).
I'd suggest you use an unbound Form, and add the Command Buttons you need to
open the Forms for each "feature" you include in your switchboard...
assuming you already have those Forms defined, the Command Button Wizard
will lead you through defining them. If, as is sometimes the case, you need
to limit the Records to be displayed on a Form or Report you are opening,
you can add that functionality with just a little knowledge of VBA.
Larry Linson
Microsoft Access MVP
