Once the Switchboard form has been created by the Switchboard Wizard,
Access does not touch it, so you can make any modifications you like
in the Form code and they will be retained. Similarly, you can make
any modifications you like to the structrue and content of the
Switchboard Items Table, provided that you do not remove or restrict
any of the fields created by Access. What you can't do is persuade the
Switchboard maintenance wizard to pay any attention to your
modifications and additions, and I believe that it gets confused if
you add new "action codes". My approach, therefore, would be to add
another field to the Table, maintained manually, and modify the "Run
Report" code in the Form to look at that field and run additional or
alternative code based on its contents.
Having said all this, you will get to a point where it is easier to
create your own independent Switchboard Forms and systems than to make
extensive modifications to the default Access one
I'm using a switchboard (customized w/ about 12 buttons per form) and instead
of opening a report, I want to run some vba to open the report (setting it to
legal paper before opening). Can I change the switchboard table's argument to
run my code?
Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
