AutoSort, a Field

[Guest]

I have a form and there is a field where somebody will rank the record.

How can I mak it where it automatically sorts so that when you enter the
form it shows what is ranked the highest or number 1? Also, when after they
leave that record it autosort or something where the records are organized
from lowest to higher number.

Is this something that I have to do in the table? Or do I need to put in a
button or macro that autically sorts after teh "Rank" field has been updated.

I hope this is clear.

 

[Guest]

Chipmunk,

Rather than basing the form on the table itself, base it on a query that
selects all of the table's fields, and Sort Ascending on the Rank field.

Sprinks