VB error with Switchboard

[Heidi Harting-Rex]

Hello,

I added a few items to a switchboard (default) today and
suddently I am getting this error message:
Run-time error '2465'
MCA Trial can't find the field 'Option 9' referred to in
your expression.
when one item on the switchboard is selected.

If I try to debug and get into the switchboard code, the
line highlighted is:
Me("Option" & rst![ItemNumber]).Visible = True

Where in the heck is 'Option 9'?

Thank you!

 

[GVaught]

The switchboard form itself is not editable. However, you can change just
the forms title. You can't edit or add to any other part of the form (not
entirely true, but for everyones safety I refuse to spill the beans). If you
do, you run the risk of corrupting the switchboard. The switchboard should
only be edited using the switchboard manager and there is a restriction of
eight items per switchboard menu. Thus, Option 9 means you have exceeded the
limitation.

 

[Shane Andrews]

Heidi,

If you look in the Tables section of the Database window, you will see
an entity named Switchboard Items. In this table you will find, in a pretty
straight-forward format, the items from your switchboard. You can see,
after a few minutes of study, which items are switchboards, and which items
are action items, which either open up other switchboards, or perform some
other function. Look for number nine in there, and you may find the
problem.

Also, you may want to experiment with adding an item to your switchboard
from the wizard, and then open this table, to see what changes were made.
Heck, you may even become proficient at writing switchboards without the
wizard!

Hope this helps,

Shane Andrews

Just possibly in the table SwitchboardItems which the Switchboard Wizard
creates and maintains.

I've never delved into the switchboard functionality. When the dang thing
breaks I usually delete the existing Switchboard form and the
SwitchboardItems table and start over. In some instances I've just
abandoned their switchboard and created my own hierarchy of forms.

HTH
--
-Larry-
--

Hello,

I added a few items to a switchboard (default) today and
suddently I am getting this error message:
Run-time error '2465'
MCA Trial can't find the field 'Option 9' referred to in
your expression.
when one item on the switchboard is selected.

If I try to debug and get into the switchboard code, the
line highlighted is:
Me("Option" & rst![ItemNumber]).Visible = True

Where in the heck is 'Option 9'?

Thank you!