Access 2003 Switchboard maximim items?

[Sue]

I cannot add beyond 8 items on my Switchboard. Each item runs a small report.

The error I get is:
"Run-time error '2465'
Microsoft Office Access can't find the filed 'Option9' referred to in your
expression"

I even tried skipping 9 and going to 10, but then it refers to Option10.
Is there a limit?

Thank you
Sue

 

[Beetle]

The Access switchboard has a built in limit of 8. You can get around it, but
it requires some coding. It may be better to create your own form to use as a
switchboard using command buttons programmed to open the forms/reports that
you want. This will give you more flexibility in the future to add more items
if needed.

 

[Sue]

Thank you Beetle -

You are much more help than the Access "help" files. I will create a form.

Happy New Year to you.

Sue

 

[Pat Hartman]

The switchboard form is relatively easy to modify to allow for more than 8
items. You need to copy the existing control and use the same naming
pattern. Then I think only two lines of code need to be changed. But once
you do that, you are relegated to making item changes to the Switchboard
Items table rather than using the wizard because the wizard only recognizes
8 items per switchboard page.

You can however, create an unlimited number of switchboard pages so you
actually have to limit as to the choices the switchboard will present. You
only have to organize them into chunks of 8 or actually 7 since you always
want to leave item 8 as the exit or return to previous menu option.