Sub Report Changes Values When Placed in Main Report

[jnes006]

Hello



In Access 2010, I have a simple sub-report I use to count a field. Works perfect by itself. However, when I place it in the main report the results change. And it doesn't matter where I place it in the Main report, it still returns a low count. Is there some filter I am missing?

Thanks

[June7]

Are the Master/Child Links properties of subreport container set? That could filter out some records.

[jnes006]

Hi, thanks for your response.

I do have the master/child fields set based on a date field. I hope to have the sub report and main report return monthly results. Is it correct the master/child need to be linked?

thanks

[June7]

If you want the main and sub reports to be synchronized.

The subreport probably isn't filtered to particular month when it is opened stand alone so all records regardless of month are included.

[jnes006]

Is there a way to keep the sub and main reports synchronized, but have the correct results the sub report produced when opened stand alone?

thanks again

[June7]

Pass month filter criteria to the report when opened stand alone. Assuming you have a date field, something like:

DoCmd.OpenReport "report name", , , "Format([datefield], 'yyyymm')=" & Me.textboxwithYearMonthValue