Filtering subforms

[lecoughlin]

I have a form that contains 3 subforms. My database has information
over time for all of the information contained on the subforms. Right
now, the recordsource for each subform is a query that contains data
only for the reporting period I'm interested in. Since I have 10
reporting periods I'd like to be able to look at separately, I have
created queries for each of the reporting periods and multiple forms
to display the data. I feel like there must be a simpler way to do
this -- ideally I would like to have a drop down box that asks the
user to select which time period they would like to look at - and if
they select the FY07 reporting period, the data in all the subforms
would update to only include FY07 data. I'm not sure how to go about
doing this.

I hope that makes sense. Any help would be greatly appreciated.

 

[Wayne-I-M]

Hi

Since I have 10
reporting periods I'd like to be able to look at separately, I have
created queries for each of the reporting periods and multiple forms
to display the data.

You could use just one query and one form. Set the criteria in the base
query to filter to only the dates you need to view

 

[lecoughlin]

Yes, that doesn't answer my question exactly but I appreciate the
help. Any ideas on the rest of my question?