Sub report dates. I have report with 2 sub reports attached.

[justme43]

I have report with 2 sub reports. the sub reports provide balances for the main report. this is sub 1 provides balance to end of last month. sub 2 provides balance for current month.

In the criteria of each query I have these expressions
sub 1: <=[reports]![rptstats]![txtdateto]

sub 2:>=[reports]![rptstats]![txtDateFrom] And <=[reports]![rptstats]![txtdateto]

these work fine returning correct balances.

Problem is I need to retype the required dates several times.

can anyone advise or suggest a better way of doing this report.

thanks

[zmbd]

Version of Access?
---
Use a form to hold the information and then refer to that form is the normative.
either via:
MS Access: Using parameters with queries and reports (ACC2003)
I know that this is for ACC2003; however, this is the same in ACC2007/2010/2013

or
Open the report in code and pass parameters to the report.
OpenArgs Property (Acc2003)

-
More complex method: Use a tempvars collection member to hold the information and then refer to that member of the collection in the formula

[justme43]

thanks for the referral link I am trying to work my way through this at the moment. thankyou again for your help and advise.

[justme43]

I have followed the instructions on the link you suggested but still have the same problem. it request date and item twice and every time I move the mouse it requests the information again.
Do you have any other suggestion or a reason why this is happening