G
Guest
I would like to filter a subform usint the content of two combo boxes. My
database has two table:
tblCities
Fields, ID (primary), City,State
tblMeasures
Fields: ID, Year, Measure1, Measure2, etc.
Relationship is ONE (tblCities) to MANY (tblMeasures) on the ID field.
In a form I have the following: One combo box selects the year. Its record
source is a "Select Distinct" SQL statement from tblMeasures.
The other combo box selects the state; also a "Select Distinct" SQL
statement from tblCities.
I have the two combo boxes in the form header along with a button called
"Refresh."
I want to be able to select a year, then select a state, then click the
Refresh button and have the subform repopulate accordingly. (Subform is a
continuous form.)
I've read several posts and other sites but haven't found a solution yet.
Thanks in advance.
Jerry
database has two table:
tblCities
Fields, ID (primary), City,State
tblMeasures
Fields: ID, Year, Measure1, Measure2, etc.
Relationship is ONE (tblCities) to MANY (tblMeasures) on the ID field.
In a form I have the following: One combo box selects the year. Its record
source is a "Select Distinct" SQL statement from tblMeasures.
The other combo box selects the state; also a "Select Distinct" SQL
statement from tblCities.
I have the two combo boxes in the form header along with a button called
"Refresh."
I want to be able to select a year, then select a state, then click the
Refresh button and have the subform repopulate accordingly. (Subform is a
continuous form.)
I've read several posts and other sites but haven't found a solution yet.
Thanks in advance.
Jerry