G
GHawkins
I'm running Access 2003 SP2. I have an ADP database with SQL tables.
I'm working with a form that is currently sorted by a unique Transaction ID,
showing oldest/lowest ID first and the newest/highest ID last. The form has a
button allowing you to apply custom filtering to it. It filters by date
range, category, and subcategory. It works fine, until I change the sort
order. When I sort it in Descending order - with the newest transactions
first - the filter doesn't work. It looks like it's being applied as far as
the screen flashes as it does when running the query, but I can still see all
of the records (on the bottom of the form, where it shows you what record you
are on out of x records).
Is there some type of limitation the filtering function has when your data
is sorted in a certain order? I'm using the ServerFilter and
ServerFilterByForm code to do the filter. Is there a better way to do it?
I'm working with a form that is currently sorted by a unique Transaction ID,
showing oldest/lowest ID first and the newest/highest ID last. The form has a
button allowing you to apply custom filtering to it. It filters by date
range, category, and subcategory. It works fine, until I change the sort
order. When I sort it in Descending order - with the newest transactions
first - the filter doesn't work. It looks like it's being applied as far as
the screen flashes as it does when running the query, but I can still see all
of the records (on the bottom of the form, where it shows you what record you
are on out of x records).
Is there some type of limitation the filtering function has when your data
is sorted in a certain order? I'm using the ServerFilter and
ServerFilterByForm code to do the filter. Is there a better way to do it?