listbox to manipulate order of categories in report

[Happy YN]

I have a report which is grouped by categories. I want the default to be that all categories are reported but sometimes the user would want to eliminate some categories or to order them according to his wish (no specific thing to perform an order by on). I have a form with 2 listboxes the first listavailable contains the categories ,the second lstselected contains the ones to go in the report. with buttons I can manipulate which ones go from lstavailable to lst selected and also bump them up or down until the derired categories are ordered to the users wish in listselected. But how can I now force my report to use this second listbox to set the requiremnts for the report until the next time it is changed
Thanks

 

[SteveA]

Please only post your question to one forum. If you are uncertain which forum it belongs in, play it safe and place it in General.

I have responded to your posting in the Forms forum.

Cheers
SteveA