Main Form Cannot Generate Query Output

[edisonl via AccessMonster.com]

Hi,

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

' Anyone care to share or provide some tips ?

End Sub

' Edison

 

[Marshall Barton]

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.