G
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.
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.