Using the same query in multiple subforms

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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!
 
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.
 
Back
Top