Hello, this is the issue I'm trying to fix. Hope to get some help.
I got 3 objects:
1. a form (frm_Scelta) with a combo box (cmbTurno), a list box (lstGL) and a button (btnInvia) that opens the report.
2. a query (Qry_Rpt) whose criteria have been selected in frm_Scelta, to populate the report.
3. the above mentioned report (rptStudenti), populated by the query Qry_Rpt.
Theoretically the form (which is a combo box and a list box) should pass their data the query as its criteria in order to populate then the report, problem is nothing get parsed.
Funny thing is that if I set the list box Multi Select property to None ( to work like another combo box) it seems to work: the report is opened and correctly filled with data.
I know that there's no way to use a multi-select list box without using code.I'd need to create the Where clause by looping through the selected items, and dynamically recreate the query, which I'm not able to do.
What am I missing?