Subforms

[GR]

Hi,
I want to load subforms depending on the selection on an
Option Group.

Until now I've thought on creating a Forms with all the
subforms and make them visible or not depending on the
option but I think this is not very efficient (or it is)
Is there another way to accomplish this?

thx.

 

[John Vinson]

Hi,
I want to load subforms depending on the selection on an
Option Group.

Until now I've thought on creating a Forms with all the
subforms and make them visible or not depending on the
option but I think this is not very efficient (or it is)
Is there another way to accomplish this?

thx.

Actually there is. You can have a Subform control with *no* form in it
- just have the SourceObject property blank. In the Option Group's
AfterUpdate event set the SourceObject property of the subform control
to the name of the form you wish to see.

You're absolutely right about the inefficiency, by the way - ALL the
subforms will be requeried and repopulated before the mainform can
open. This can cause opening your form to be rather slow!