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

  • Thread starter Thread starter Antonio
  • Start date Start date
A

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
 
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
 
I would try using a Tab control on a form and embed each of the other forms,
one per tab, as subforms.
 
Back
Top