Subform Selection

[doug adams]

I am relatively new to access and here is what I need to do:



- I have a total of 5 forms in my DB
- I have a combo box that refers to the names of 4 of the boxes
- I need to display one of the forms selected from the combo box as a subform in the 5th form.
- I have tried using the SourceObject property but it does not work.
- Probably, I am missing out on some preliminaries which is the cause of the error.

Please help me on this

Thanks

[ansentry]

This I don't understand;

I have a combo box that refers to the names of 4 of the boxes

What code are your using?

I need to display one of the forms selected from the combo box as a Subform in the 5th form.

Why not just insert "one of the forms" as a Subform?
or
Do you want to use the 5th form to display the any one of the four other forms as subform, with the selection being made via your combo box?

[doug adams]

I have a total of 5 forms in my database. (Say frm1, frm2... frm5)
In frm5, i have a combo box whose rowsource contains the names of frm1, frm2, frm3 and frm4.

In frm5, i also have a subform object to which i have not assigned any Form initially.

When the user selects a particular form (frm1, frm2, frm3 or frm4) from the combo box, i want the subform object to display the selected form.

I tried using the code:

Set Form_frm5.Child0.Sourceobject = Combo1.Value

The application returned an error which said 'Cannot find the said object Child0 in frm5'.

Please help.