Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how do you use a combo box to move from form to form

0 views
Skip to first unread message

Antonio

unread,
Nov 6, 2003, 1:00:41 PM11/6/03
to
I have a number of Forms (5 to be exact) and I was
wondering if there is a way to jump from form to form
using a combo box. I am currently using command buttons
but they seem to make the form look clunky and out of
date, no matter what I do to them. If you can't use a
combo box I would appreciate any other ideas.

I could really use the help,
Thank you,
Antonio

Dan

unread,
Nov 6, 2003, 1:46:18 PM11/6/03
to
Good Afternoon!

Set up your combo box so it displays the exact names of
the five forms. If the name of your combo box was Combo1,
in the After Update Event of the combo box you would enter
the following code:

DoCmd.OpenForm Me.Combo1.Value

>.
>

Roger Carlson

unread,
Nov 6, 2003, 3:39:58 PM11/6/03
to
I would try using a Tab control on a form and embed each of the other forms,
one per tab, as subforms.
--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Antonio" <anon...@discussions.microsoft.com> wrote in message
news:01ad01c3a48f$e493b5b0$a301...@phx.gbl...

Michael San Filippo

unread,
Nov 6, 2003, 4:29:09 PM11/6/03
to
I agree - tabcontrols look slick and they are easy to do.

"Roger Carlson" <carl...@hotmail.com> wrote in message
news:uwj0lYKp...@TK2MSFTNGP12.phx.gbl...

0 new messages