Using the same query in multiple subforms

[Jeff]

I want to have a form with multiple subforms that show data of different
dates. I do have a query that displays in one subform. So I would like to
create multiple subforms using the same query. How do I set the different
dates into the subforms query? This is hard to explain!

 

[Allen Browne]

Could you set the RecordSource of your different subforms like this:
SELECT * FROM MyQuery WHERE [SomeDateField] > #1/1/2003#;

Use whatever WHERE clause is appropriate to the different subforms.