My Switchboard Rollercoaster

diplomat

Registered User.
Local time
Today, 00:26
Joined
Mar 26, 2000
Messages
12
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
 
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.
 
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...
 

Users who are viewing this thread

Back
Top Bottom