(While anyone can help me with this, Hans, you offered me a solution a couple of months ago- I should have taken it!)
I would like to develop a form that captures criteria from the user to be used to run a query (that would either be displayed in a bound subform or in a new form- doesn’t matter).
For example, the user selects firm size (combo/list box), age of firm (combo/list box), and three other Yes/No check boxes. Upon completing this selection process, (perhaps an “update” control button is clicked) a query is generated based on these criteria and ran, with the results displayed in the subform or in a new form.
(I know how to control a form from one combo/list box, but I can’t extrapolate this knowledge to a multi-field query.)
Any example will help.
Thanks,
Brandon.