Find Form

[Guest]

I am trying to develop a form that can be used to search and/or create
reports based on selection criteria. Many of the fields were made into list
boxes with multi select property set to extended. I used some code to get
the list box results to show up in a text field (to make sure the results
were correct).

The results then go to a query, and i have 2 problems with this.
1. I added a "&" at the end of the If statement in a For.. Next loop to
have the results go straight into the query. I can't get rid of the & that
is added after the last record
2. The results are sent to the query. I used an expression to verify what
was being sent to the query and all looks well, however, the query does not
work.

I would appreciate any help regarding this issue.

 

[Allen Browne]

A query cannot read the items in a multi-select list box directly.

If you are targetting a report, it's probably easiest to loop through the
ItemsSelected and build the WhereCondition for the OpenReport action.

Details in article:
Use a multi-select list box to filter a report
at:
http://members.iinet.net.au/~allenbrowne/ser-50.html