Changeing Report Filter

[stoka]

have a report with a front end form to get date ranges and sorting order. used vb code to lauch one of two reports (one for sort by name, another for sort by date -- didn't know how to change sort order in report from the form) so now i want the ability to use a combo box in the form to select a particular person, and pass that as a filter to the report. it currently accesses a query with no sorting and the sorting setup is in the report grouping area. any help ?

 

[pbaldy]

You can use the wherecondition argument of OpenReport to restrict the report. And you could have used code like this in the open event of the report to test the form and set the sort order:

Me.GroupLevel(0).ControlSource = "CustomerName"