Switching between linked forms and subforms

[gkl]

Dear All,

Let's say we have the classical Customer-Order one-to-many scenario and I want to build a form that shows customers and their orders. I start with the Form Wizard and at some point in the process I have to choose between a subform and a linked form.

Let's assume that I go for the linked form option. I preview it and I don't like it and I would rather go with the subform option. Is there a way that I can change this setting from the interface rather than re-creating the form (what about VBA)?

Regards,
George

 

[CJ_London]

in design view just drag the linked form from the navigation window onto the relevant form.

You may have other things to do to make it work - like set the link child/master properties in the subform control