MSAccess, change sorting on subform based on value on listbox
Posted on 2012-03-28
I am using MSAccess 2003.
Have a list box on a form with 2 values, "CA","NV"
When list box is clicked, it filters the data on a subform. Pretty simple program.
Problem is, I need the sort order to be different if CA is selected and another way if NV is selected.
CA - sort order is CustName, City, Rep
NV - sort order is Rep, City, CustName
any ideas on how I could do this?