how to open one form from multiple forms using combo box in access 2007

[prabhatjain]

i have one main form in which i insert combo box in which i put name of the forms manually. now on selecting any particluar form name from combo box i want to open the form containg that name without having master child relations . pl let me know coding to allow opening of form on the basis of name selected from cobo box value(form Name)with hiding the main form simultiniously

[twinnyfo]

prabhatjian,

Welcome to Bytes!

Your problem is relatively simple:

Call DoCmd.OpenForm(FormName:=Me.ComboBoxName)
Me.Visible = False

Hope this hepps.

[NeoPa]

I think you need a little more than that Twinny :

Private Sub ComboBoxName_AfterUpdate()
    With Me
        Call DoCmd.OpenForm(FormName:=.ComboBoxName)
        .Visible = False
    End With
End Sub

The sub declaration line is relevant and important in this case I would say.

[twinnyfo]

@NeoPa
True. But I did not want to presume on when OP wanted the code to execute.

Your solution is certainly more elegant. I’m just a bum from the slum!

;-)

[NeoPa]

I was going by the wording in the OP.

PrabhatJain:
now on selecting any particluar form name from combo box i want to open the form containg that name

I understand it wasn't 100% clear ;-)