Switchboard vs Form

[Guest]

I had 12 buttons with macros opening 12 different forms all on one Form that
I titled startup and used as a switchboard.

An IT person told me I'd have quicker acces into the actual forms if I used
the Access switchboard, which I think turned out to be true (by a couple
microseconds)...but I can only have eight buttons on the switchboard, so it
takes longer going to another switchboard to find the form I want to enter
into.

Is there a better way of doing this?

 

[Jeff Boyce]

How long the forms take to open is more a factor of what's on the forms and
how many records they're tied to. My mind doesn't usually perceive
microsecond differences, so I couldn't tell you if a switchboard works
faster than a macro.

For just the reason (i.e., limitation) you gave, I use my own form rather
than a switchboard. Rather than macros, I use the DoCmd.OpenForm command in
code behind the button. You wouldn't even need to write the code, as the
command button wizard would do that for you.

Just one person's opinion...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor

 

[Tim Ferguson]

=?Utf-8?B?ZnJhbmtsaW5idWtvc2tp?=

I had 12 buttons with macros opening 12 different forms all on one Form

What _is_ the difference between that and a switchboard?

Tim F

 

[Brendan Reynolds]

=?Utf-8?B?ZnJhbmtsaW5idWtvc2tp?=


What _is_ the difference between that and a switchboard?

4.

Well, you did ask!

 

[Guest]

Bob,

Thank you so much, this MORE than meets my intent, and saves me much time.
Just AWESOME! Thank you!