Use form to open report

[jefferyzhong]

hi,
I have a form, which has begindate, enddate, customer and report type...
I have several reports can be opened by this form.
before, the "customer" is a combo box which means I only can select one of them, I set the report!Rptsales![Customer]=forms!Frmreport![Customer],it works well, there is no problem.
now I am request to have the customer multiple selection, which means, I might need 2 or 3 customer selected at one time, I can make multiple selection, but the report does not work! I tried several ways which all do not work!

can anyone tell me how to solve this problem?

thanks in advance!!

Jeffery

 

[Remou]

Hi
I think this may help:
How to use Selected Items from ListBox as query criteria
faq701-4432

You can then base your report on the query.