Hi
I have created a form that has a listbox the selection from the list box is used as a parameter to open a report that show only the data for the selected Employee. I created a macro to open the report and in the Where Conditon My code is [EmpLName]=[Screen].[ActiveForm].[list9]. This does work , but now I would like to change the listbox to a multi selection, so that the user may select from the listbox more that one employees name at a time and my report would open only shown the data for those employees selected. I have changed the Multi Select property to Simple.
How do I change my Where Condition to allow for the multi selection
Any help would be appreciated
Thanks
Liz
I have created a form that has a listbox the selection from the list box is used as a parameter to open a report that show only the data for the selected Employee. I created a macro to open the report and in the Where Conditon My code is [EmpLName]=[Screen].[ActiveForm].[list9]. This does work , but now I would like to change the listbox to a multi selection, so that the user may select from the listbox more that one employees name at a time and my report would open only shown the data for those employees selected. I have changed the Multi Select property to Simple.
How do I change my Where Condition to allow for the multi selection
Any help would be appreciated
Thanks
Liz
