Passing Query Criteria to subform queries?

[tmartin]

I have been given a report that has many sub-forms that each have their own query. Currently the date for the report is fixed to the current date.


Three of the sub-queries use DatePurchased while the other two use just the Date field. I was trying to assign an alias "mydate to all five to have a common date field
so that I can pass the query to all five sub-queries.

e.g.

mydateatePurchased
mydate:date

After this task then I am done so want to get this off my plate. How do I pass criteria to sub-queries for each sub-form?
Thanks

[June7]

You are using forms as subreports? Don't think I've ever seen that. The disadvantage may be that forms will not grow. If you know the number of records will not exceed the size of form, then maybe okay.

The issue of applying filter criteria to subform/subreport sounds like same issue discussed in: https://www.accessforums.net/program...tes-49268.html

Don't really understand 'pass the query to all five sub-queries' - did you mean 'pass criteria'? I don't think the common alias field name will resolve the issue.


Date is a reserved word and should not use reserved words as names.

[tmartin]

I resolved the issue by adding a reference in the sub-queries to get the date value from a text box in the form.