Sorting in forms

  • Thread starter quinto via AccessMonster.com
  • Start date
Q

quinto via AccessMonster.com

I have a form with several control fields.
I use a query to sort 3 field and when I opn the form it is fine but if I
sort by another filed it will not go back to the original sort when I reopen
the form. Is there a way to maintain the original sort but with the
permission to custom sort in the form?

I added the sort is the Order By control but that changes if I right click
and sort in another field.

Quinto
 
B

boblarson

You are probably suffering from a persistent filters problem. I would
suggest just putting the sort order you want as a default into the form's On
Load event and go from there.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________
 
Q

quinto via AccessMonster.com

Yes I thinbk that is what I need.
Can you direct me how.
It looks like I need macro but I do not see a choice for sorting or order.

Thanks

Quinto
 
Top