Subform Question

[Christopher Austin]

I have a form that includes three subforms. All 3 subforms
are not always necessary to fill out. However, if one of
them is left empty, they will not query. I tried using
default values for their tables but that doesn't work. Is
there anyway I can autofill the subforms whenever the part
form is opened?

chris

 

[Michel Walsh]

Hi,

You can change the form used, displayed, in the control (call the sub-form control), through
the SourceObject property.


Me.MySubFormControlName.SourceObject= strNameOfAFormDisplayingNothing


will change the actual display (in the control) for the form you specify. That said form can be
plain (blank), or with just with a label ( Not Applicable ), or as you wish, really.


You can even use that technique to write your own wizard, displaying a new form for each
"step", the main form having the (sub-form) control and the navigation button (Previous, Next,
Finish, ... )



Hoping it may help,
Vanderghast, Access MVP