Report is based on the listbox row source

[polina]

I have a listbox with many columns and rows.
User has an option to sort that listbox. so everytime the RowSource of that list would be different.

Based on that RowSource sql I want to print the report.

How would I pass the current RowSource to the report?

Thanks

 

[IfButOnly]

Polina,

I think all you need to do is:-

Report.rowsource = forms![form_name]!list_box.rowsource
(not sure off hand of the correct ! and . placements)

when you click the report button is should pick up the current rowsource sql from the list box.