multiple choices on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
how can i add multiple choices on a form. users should be able to choose
from eg. district and/or scale and the subform should show the results of
either one or both choices
 
one way to do this; in general terms;

source the subform on a query

have the query's criteria(s) sourcing from those combo/choice boxes on the
form
 
yeah right ...

i already did that but the subform only reacts to both criteria. i also want
the subform the react to one criteria. so both possibilities should be
included in one form; criteria A, Criteria B, criteria A+B. the subform
should react accordingly.
 
you are more than half way there....


make non visible unbound text boxes on the form and make these the source
for the criteria of the query rather than the comboboxes; force these to
default to wildcard "all" or a value you know is so broad it is effectively
'all'

AfterUpdate of the comboboxes have their selected value written to the
unbound text box...

In this way either one or both comboboxes would present criteria to the
query; while an unselected combobox would be defaulting to the nonfiltering
"all" query

will take a little tweaking to anticipate user's options and
requerying...but should work...
 
Back
Top