Sort (order) data on forms

[atisz]

Hello,

This is related to "Old_value, new_value" thread I posted yestarday.

I have a problem i missed yestarday. The code it's vorking great, but it allways takes the showed new_value and makes it old_value for the new record, and this is a problem, because the showed record is not the last for that customer.
So, I was thinking that if I make a new Autonumber field in my table, I could sort descending the values and this way the input form will allways show me the last entered data for that person.
As I noticed from a long time ago, if I sort a table that allready has a form, the form won't show the records sorted. Why? It's necessary to make the form again? I tried to order the data on the form from Properties window ->Data->Order by, but the ordering is Ascending and I need it Descending!
Can enybody help me?

Thanx,
Attila

 

[maxmangion]

while you are in the form, click on the field you want to sort with and then from the toolbar click on the Z-A icon (Sort Descending).

 

[atisz]

Upsssssssssssss! Is that simple, and I didn't knew? Shame on me.
Thanx a lot.

Attila

 

[maxmangion]

you're welcome