edisonl via AccessMonster.com wrote:
[Quoted Text] >Private Sub FunnyQuestions()
>
>' I got a 'funny questions' that puzzled me.
>
>' My main form contains mutiple tab control, within each TAB control consist
>of subform.
>' NOTE: All subform are not bound to main form in any way.
>
>If (I run the subform individually) then
> Able to see the output.
>
>ElseIf (I run the form) then
> Can't view the output from this subform.
>End If
It sounds like the forms used as subforms have their
AllowAdditions property set to No AND somehow their data is
filtered in such a way to return no records. For subforms,
the most common filtering is done by the subform control's
LinkMaster/Child properties. In your case, I think you need
to make sure these properties are empty. Less likely, but
possible, the forms' Filter property has be set to something
unusual or there is an odd crtieria in their record source
query.
--
Marsh
MVP [MS Access]
|