How to show particular form in sub form?

[peter]

Dear All,
A combo box which contained form names will be shown. When user click
and select
a form name from the combo box, the particular form mensioned in combo
box will
show in the sub form.

How to perform this task in access 2002 VBA.

Thanks in advance.

Regards,
Peter

 

[Allen Browne]

Set the SourceObject property of the subform control in the AfterUpdate
event procedure of the combo, e.g.:
Me.[Sub1].SourceObject = "Form1"

Will will need to check LinkMasterFields and LinkChildFields after that.
Access will have a guess at them, but it may not be what you want.