Tab control Integrity

[Frank Situmorang]

Hello,

On the Tab Control, I have one tab for all transactions report below, and
the latter is for outstanding only, but the problem is if I directly click
for outstanding only, no report shown, although there is outstanding amount.
I should run first all transactions tab, then I run the the outsstanding tab
control, then it works.

What should I do, in order to eventhough I jump the 2nd tab, I still can
run the report.

Below is my VBA.

I appreciate if anyone can help me on this.

With many thanks,

Frank

Private Sub OpenReport1_Click()
On Error GoTo Err_OpenReport1_Click

Dim stDocName As String

stDocName = "Aging Supplier Details Grouping by Suppliers_Select"
DoCmd.OpenReport stDocName, acPreview

Exit_OpenReport1_Click:
Exit Sub

Err_OpenReport1_Click:
MsgBox Err.Description
Resume Exit_OpenReport1_Click

End Sub
Outstanding only:
Private Sub ToOpensupplierOSonly_Click()
On Error GoTo Err_ToOpensupplierOSonly_Click

Dim stDocName As String

stDocName = "Aging Supplier Details Grouping by Suppliers_Select_OSonly"
DoCmd.OpenReport stDocName, acPreview

Exit_ToOpensupplierOSonly_Click:
Exit Sub

Err_ToOpensupplierOSonly_Click:
MsgBox Err.Description
Resume Exit_ToOpensupplierOSonly_Click

End Sub

 

[ErezM via AccessMonster.com]

hi
it's a bit hard to tell what the problem is, but one thing that might happen
is that the All report is filling a temporary table that the filtered report
then uses - to check if this is the case, is there any code running in the
report's Open event? does it fill any tables?

good luck
and if none, please try to explain again, in more detail

 

[Frank Situmorang]

Thanks ErezM, if fact I am wrong, the filter in my query refers to another
combo in other tabcontrol, I forgot to change it.

Thanks for your comments