View Full Version : forms sort restore


skelley
07-26-2000, 03:25 PM
Have a form based on a query that sorts my form based on 2 fields in descending order. When a user applys a filter or sorts it another way, that user gets that same sort the next time he opens it and I can't restore the original 2-field descending sort that the query originally had it in.

Can someone help me?

tbprog
07-27-2000, 01:06 AM
Hi is the sort order defined in the query or on the form.
If in the query ensure that the forms ordeby is blank on opening the form