I have a report which needs to sort registered voters in my state, the report is generated from a form with a combo box "Sort by...."
I would like to be able to sort the report by Last Name or the Precinct the person lives in.
The drop-down box I created in the form has "Last Name", "Township ID". So, it follows that in the Access Report, Design View, Sorting and Grouping, I have the expression [Sort by] ---> "[Forms]![FormSelectCriteria].ComboSort".
This works about as well as a one legged duck swimming in a toilet bowl........you get the idea. Any suggestions out there???