Help with VBA to have combobox open/close forms

[templeowls]

Hi, I'm looking to see if its possible to have code open and close various forms based on a combobox.

Basically, I've got form1, form2, and form3. I want to have a combobox allows the user to select one of the three forms in order to change forms quicker. So basically if the user is in form1, and selects form2, then the code would close form1 and open form2.

Any recommendations on how to code it? I found one tutorial online but its for opening subforms within a main form via a comboxbox. I'm looking to do it for 3 distinct main forms.

Thanks!

[Bob Fitz]

Set the Row Source property of the combo to Value List
Set the Row Source property of the combo to form1; form2; form3
In the After Update event of the combo use Select Case to determine which form has been selected.
One line of code to open the selected form and another to close the current form.
Post back if you need help with the code for the After Update event.

[Gicu]

The code would look something like this

'save record as you are about to close the form
Me.Dirty=False
Docmd.OpenForm Me.cboFormSelector
Docmd.Close acForm, Me.Name

Cheers,

[Bob Fitz]

Hi, I'm looking to see if its possible to have code open and close various forms based on a combobox.

Basically, I've got form1, form2, and form3. I want to have a combobox allows the user to select one of the three forms in order to change forms quicker. So basically if the user is in form1, and selects form2, then the code would close form1 and open form2.

Any recommendations on how to code it? I found one tutorial online but its for opening subforms within a main form via a comboxbox. I'm looking to do it for 3 distinct main forms.

Thanks!

Here's an example of how it might be done:

[templeowls]

Thank you so much!!