K
Kevin
I have a number of reports that generated based on criteria chosen in a
multi-select list box form. The WHERE clause in the form’s code is as
follows:
" WHERE Project.ProjectID = " & Me.cboProjectName & " And (Bid.BidNumber) in
(" & strCriteria & ")" & _
It works great because there are 4 different reports based off of the same
query because the criteria is the same for all four. I have another report
that requires one additional criteria, so I created a different query. The
field in that query is “Product.LibraryReference†and the criteria I need to
always maintain is “9.01-A.1â€.
When that criteria is set, the query and report yield the desired results,
but when I generate it using the multi-select list box form, it eliminates
the criteria which results in incorrect results. I’m not a code expert, but
I believe I need to add something to the WHERE clause to account for the
criteria listed earlier. Am I correct in thinking this, and what code would
need to be added to achieve this? Thank you in advance for any help!
multi-select list box form. The WHERE clause in the form’s code is as
follows:
" WHERE Project.ProjectID = " & Me.cboProjectName & " And (Bid.BidNumber) in
(" & strCriteria & ")" & _
It works great because there are 4 different reports based off of the same
query because the criteria is the same for all four. I have another report
that requires one additional criteria, so I created a different query. The
field in that query is “Product.LibraryReference†and the criteria I need to
always maintain is “9.01-A.1â€.
When that criteria is set, the query and report yield the desired results,
but when I generate it using the multi-select list box form, it eliminates
the criteria which results in incorrect results. I’m not a code expert, but
I believe I need to add something to the WHERE clause to account for the
criteria listed earlier. Am I correct in thinking this, and what code would
need to be added to achieve this? Thank you in advance for any help!