I wish to open a report and restrict its record to those selected in a listbox. If I set multiselect property of my list box to none, I can make one report selection using this code in the WHERE clause of my macro:
=IIf([Forms]![Test]![Select Level] Is Null," ","[Level]=Forms![Test]![Select Level]") set
However, I will like to set the multiselect property to simple so as to allow the selection of multiple records to print. My question is how do I manipulate the code above, or is there a better way? Thanks a lot.