P
Paulo
I built first a form with 3 combo boxes (all of them with the "All" option
created using a Union query) and a subform. Form and subform are linked
(Master/Child fields) via the combos. I also tweaked the SQL code for the
subform query, following advice from this forum, so that any combination of
choices in the 3 combos (including "All" for any of them) generates the right
set of records in the subform. Perfect so far, with 3 combos, because the
number of combinations is not too much. But if I try to expand to 7 combo
boxes (i.e. 7 different fields to filter the data, and taking into account
the "All" option in all of them as well), I cannot any more just adjust the
SQL code of the subform query, because the number of possible combinations
becomes staggering. Would the viable solution in this case be via form code,
instead of changing the SQL code in the subform query? Can you make any
suggestions?
Thanks in advance,
Paulo
created using a Union query) and a subform. Form and subform are linked
(Master/Child fields) via the combos. I also tweaked the SQL code for the
subform query, following advice from this forum, so that any combination of
choices in the 3 combos (including "All" for any of them) generates the right
set of records in the subform. Perfect so far, with 3 combos, because the
number of combinations is not too much. But if I try to expand to 7 combo
boxes (i.e. 7 different fields to filter the data, and taking into account
the "All" option in all of them as well), I cannot any more just adjust the
SQL code of the subform query, because the number of possible combinations
becomes staggering. Would the viable solution in this case be via form code,
instead of changing the SQL code in the subform query? Can you make any
suggestions?
Thanks in advance,
Paulo