Well, this worked out just great. I am not sure how what I did could have
caused a new problem but now my switchboard no longer works. I get a runtime
error "2110" stating the focus cannot be moved to the control Option1. Here
is what I did...
Opened up the Switchboard Items table
Renumbered the item numbers so I could insert new records ..this is so I
could have the menu be item 1 of each SwitchboardID
I then cut the OptionLabel1 box and repasted it to the form so I could
disconnect the label box from the command button Option1
I then deleted the command button Option1 from the switchboard form
I tried to open the switchboard form but I got a runtime error "2465"
stating the field Option1 referred to in my expression could not be found
So, I clicked on the debug box and saw the focus was set to the Option1
command.....Me![Option1].SetFocus
I changed that command from Option1 to Option2........Me![Option2].SetFocus
I tried to open the switchboard and now got a runtime error "2110" stating
the focus cannot be moved to the control Option2
So, I clicked on the debug box again and changed things back to the initial
settings..to Option1.....Me![Option1].SetFocus
I then added a new command button back to the form and reassociated the
OptionLabel1 to the new command button
I then renamed the new command buttn to Option1
I still get a runtime error stating the focu cannot be moved to Option1..I
think this is because in the VB window there is no Option1
So, any clue how to fix my switchboard, and
what did I do wrong when trying to add the menu to be item 1 in all the
switchboards?
KARL DEWEY said:
This is a sample of my Switchboard Items table.
SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Switchboard 0 Default
1 1 Main Menu 1 1
1 2 Process Improvement Ideas 1 2
1 3 Corrective Action Request (CAR) 1 3
1 4 Reports 1 11
1 5 Document Audits -OLD - See Process Audits 1 13
1 6 Performance Audits 1 5
1 7 Walk Throughs 1 19
1 8 Lost Tool Activity 1 4
1 9 Process Audits 1 7
1 10 Table Update 1 6
2 0 Process Improvement Ideas 0 0
2 1 Process Improvement Ideas 1 1
2 2 Add/Update a Process Improvement 3 ProcessImprove-TAB
2 10 Return to Main Menu 1 1
3 0 Corrective Action Request (CAR) 0 0
3 1 Corrective Action Request (CAR) 1 1
3 2 Update Open CAR 3 CAR-Tab
3 3 Add New CAR 3 CAR-Add
3 4 Review Closed CARs 3 CAR-CLOSED
3 10 Return to Main Menu 1 1
4 0 Lost Tools 0
4 1 Lost Tools 0
4 2 Lost Tools Data Entry 3 Lost Tool Data Entry
4 3 Lost Tool Activity Last 12 Months 3 LOST TOOLS DISPLAY
4 8 Return to Main Menu 1 1
5 0 Performance Audits 0 0
5 1 Performance Audits 1 1
5 2 Performance Audits - All 10 Performance Audit Findings and History
5 3 Performance Audits - Active 10 Performance Audit - active
My OptionLabel1 is how I display the menu title. The menu is loaded into the
Switchboard Items table as item 1 of each SwitchboardID. Of course the
command button for options1 is removed. I changed the font (color & size)
and centered in the display.