SubReport Error

[BeffyMar]

I have a main report that is produced according to an embedded query.&nbsp;&nbsp;The person must enter in a Fiscal year and the dates are pulled from a fiscal year table and used to compare date fields in another query in the main report.<br><br>The subform uses the same first query that gets the dates.<br><br>When I run the report, it asks for the Fiscal year 4 times.&nbsp;&nbsp;How can I make it so that it only asks for the Fiscal year once.<br><br>Thanks in advance,<br>Mary Beth

 

[DreewToo]

I'd say the query should reference a form control where the date criteria is set.&nbsp;&nbsp;Try bringing the criteria form up in the OnOpen event of the report, and having the user enter their criteria there.<br><br>HTH,<br>Drew