Sorting Report

[SusanC]

Hi!
Me again...

I have a report that I would like to sort but via a form. I would like to put in a criteria and then just have those ones in the report?

I know how to sort it by going into design and grouping etc. but I need to make an easier way to access this for other people who don't know how to do that!
Is there a way?

thanks
Sue

 

[FoFa]

Typicaly I will base the report on a query, and pull the criteria from the form in the query itself. You could also pass the parameters in an openform command as a where clause to filter the data, but I usually use the first approach. Both seem to work.