48Highlander
Technical User
I have a complex nested query. I want to use the 'bottom query' to select only certain records. To detemine the values for the query criteria, I have a multi-select list box. My code determines all of the values based on what the user has selected in the list box and assembles the values into a string in the form:
5 or 17 or 26
If only one item is selected, the string looks like:
5
The code than puts this string into an unbound text box on my form. The query criteria has the following in the first criteria row:
[Forms!frmReportSelector!txtSponsorType]
The query works fine if the user selects only one item in the list box. The query returns no records when more than one item is selected.
Anybody tell me how I should be passing this filter to the query?
Bill J
5 or 17 or 26
If only one item is selected, the string looks like:
5
The code than puts this string into an unbound text box on my form. The query criteria has the following in the first criteria row:
[Forms!frmReportSelector!txtSponsorType]
The query works fine if the user selects only one item in the list box. The query returns no records when more than one item is selected.
Anybody tell me how I should be passing this filter to the query?
Bill J
