open differen forms selecting from combo box

[Azad, DH, BD]

Suppose I have a combo box in the main form and in the combo box(drop down
list) I have the names of different forms. Now I'd like to open form by
clicking the form name from the drop down list.

But I don't know how.

Can any body please please help me urgently?

Waiting for help!!!!!

 

[Dennis]

In the After Update event of the combo box put this

DoCmd.OpenForm ComboBoxName.Text

 

[banem2]

Suppose I have a combo box in the main form and in the combo box(drop down
list) I have the names of different forms. Now I'd like to open form by
clicking the form name from the drop down list.

But I don't know how.

Can any body please please help me urgently?

Waiting for help!!!!!

If the combo record source does not have ID field use:

Private Sub myCombo_AfterUpdate()
DoCmd.OpenForm myCombo
End Sub

Otherwise you need to refer to column of combo record source (counting
from 0):

Private Sub myCombo_AfterUpdate()
DoCmd.OpenForm myCombo.Column(1)
End Sub

Regards,
Branislav Mihaljev
Microsoft Access MVP