D
Dave C
I have 4 combo boxes and text boxes on a form. I have a
query that has criteria embedded to pick up the text box
values from the form. An example of this criteria: =
[Forms]![frmReportMain]![txtEffFromDate].
Using the same convention, I load a non-visible test box
with a concatenation of the combinations of values
selected from one of my combo boxes. However, the query
won't return any results if the text boxes says ie, "9 Or
10 Or 11", but it will return results it is just says "9"
or it says "10" etc. How can I get my query to
automatically pick up criteria for multiple selected
items within a combo box? As a side note, the query is
embedded within a report which is executed on a menua
after clicking criteria on a Report parameter form.
Thanks for the help!!
query that has criteria embedded to pick up the text box
values from the form. An example of this criteria: =
[Forms]![frmReportMain]![txtEffFromDate].
Using the same convention, I load a non-visible test box
with a concatenation of the combinations of values
selected from one of my combo boxes. However, the query
won't return any results if the text boxes says ie, "9 Or
10 Or 11", but it will return results it is just says "9"
or it says "10" etc. How can I get my query to
automatically pick up criteria for multiple selected
items within a combo box? As a side note, the query is
embedded within a report which is executed on a menua
after clicking criteria on a Report parameter form.
Thanks for the help!!