Select a reoprt

[Frank]

I would like to let the users select what report they want from a list of
reports, but I would also like them to be able to sort/filter the report by
their own criteria needs.

 

[Allen Browne]

Hmm. That's quite a few things you're asking for.

Here's how to select a report from at list box:
List Box of Available Reports
at:
http://allenbrowne.com/ser-19.html

Here's now users can sort the report:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

Here's how to build a filter to apply to OpenReport:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The last article has a free downloadable demo that applies its filter to the
form itself, but the code is identical to filter a report.