Combo Box_Opening Subform

[cariobulog]

How can i open a subform from a main form using a combo box?

thanks.

 

[ptpaton]

A subform is usually imbedded in a main form, and opens with the main form, so I'm not really sure what you're trying to do, but you could open the form as a dialog or normal form with any of the action properties of the combo box. Have you thought about something like DoCmd.OpenForm on the AfterUpdate property of the combo box?

A little more detail on what you're trying to work out will help.

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[cariobulog]

thanks for your time patrick!

what i want is that i want to open a form in the subform using combo box.

for ex. if i want to enter a form name in the combo box the form which i enter will automatically open in the subform.

many thanks

 

[ZmrAbdulla]

You can change the subform object... as I said in thread702-1144435

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!

 

[cariobulog]

i tried but its not working,

in the combo box i have a row source contains the names of the form and what i want is everytime i choose a certain form name in the combo box its automatically open in the subform.

many thanks

 

[cariobulog]

mr. zameer in the previous thread we did it in click event with the command button. but this time i want to choose in the combo box the for which i want to open.


thanks

 

[ZmrAbdulla]

Makes no difference, only to change the code a little.

Private Sub ComBox1_AfterUpdate()
    Me.SubFormSpace.SourceObject = Me.ComBox1.Column(0)
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!

 

[cariobulog]

thanks mr zameer, now i can start now my database