View Full Version : My Switchboard Rollercoaster


diplomat
04-14-2000, 06:09 AM
So, I made it to the stage of actually having to setup a switchboard for the first edition of my database, and I so excited. But now ran into a little problem (which maybe a big problem).
I made a switchboard with four buttons and it worked beatifully. However, what can I tell, I had to screw up. In the design view I added a fifth botton, and (here is the kicker) I deleted all of the remaining blank buttons. Something went wrong and the switchboard did not look right, so I decided to delete the fifth button and be content with the original 4 button setup which worked like a charm. That is when I got the following hieroglyphic messages when I try to test my switchboard form:

Runtime error '2465':
Microsoft Access cannot find the field 'Option5' referred to in your expression.
You have misspelled the field name or the field may have been renamed or deleted.

and when I press the debug button, I get wrapsheet with this statement highlighted:
Me("Option" & intOption).Visible = False

What shall I do? Startover? or fix it, but how?

Thanks

Pat Hartman
04-14-2000, 11:51 AM
You're going to need to start over. Delete the form that the switchboard wizard generated. It is named [Switchboard]. Also delete the table that holds the switchboard entries. It is named [Switchboard Items].

For your next version, you don't need to delete the unused buttons because they are not visible.

diplomat
04-14-2000, 01:08 PM
Thanks!! That is exactly what I did!
I needed to go thru this exercise anyway!!
It should look at my switchboard ... mirror mirror on the wall...