We Access book or people refer to the "Subform", they actually talk about 2
different entities as one (and hence it is rather confusing). The 2
entities are:
1. The SubformControl: I like to think of the as the rectangular space on
the Main Form that is reserved for the second entity. Think of this as the
container for another Form. The 3 important Properties of the
SubformControl are LinkMasterFields, LinkChildFields and the SourceObject
Property.
2. The SourceObject is another Form that is used as the "Subform" (in
general sense), i.e. contained in the SubformControl. You specify the
SourceObject by assigning the name of this Form in the SourceObject Property
of the SubformControl.
Thus, when you refer to the "Subform" or a Control on the "Subform", you
need to use the hierachical reference like:
Forms!MainFormName!SubformControlName.Form!ControlName
since the Form being used as the SourceObject is not a member of the Forms
Collection.
--
HTH
Van T. Dinh
MVP (Access)
Larry said:
I'm new to Access. Could someone please explain exactly what a
SubFormControlName is. I know that it's not always the same as the form
name. Thanks