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

[Antonio]

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]

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]

I would try using a Tab control on a form and embed each of the other forms,
one per tab, as subforms.

 

[Michael San Filippo]

I agree - tabcontrols look slick and they are easy to do.