creating reports from filtered lists (1 Viewer)

[skate]

How do I do this? Anyone know? My listbox filters according to a search and I want to give my users the option to print the filtered list. How? HELLLPP!! Thanks!

 

[edtab]

a) Create a report using the same data source as your list box.

b) Create a command button on the same form where your listbox is.

c) Run the report using a "Docmd.openreport" in the "Onclick" property of the command button.


edtab

 

[skate]

but if say the user searches for Canada, and all items are filtered to show only based on the criteria how does that effect the report? Then what if the user searches for something else?

 

[edtab]

Whatever the user filters will show in your list... at the same time, the same items will also show in your report if you choose to run it.

edtab

 

[skate]

see, it seems like too much work if i make a query for every possible search criteria the user will enter. Is there a way I can use code such that the value entered is taken and put into the query?

 

[skate]

see, it seems like too much work if i make a query for every possible search criteria the user will enter. Is there a way I can use code such that the value entered is taken and put into the query?