put records in descending order

[Dan]

i have a form that i put weekly rates in by date. i just
changed these from ascending to descending to show in the
form. my problem is when i go to add new rates it puts
them at the bottom not in descending order until i close
the form and go back in then they are in descending
order. is there code or some way that when i click the
button to add the new rates that it puts it in descending
order at that time

 

[Marshall Barton]

i have a form that i put weekly rates in by date. i just
changed these from ascending to descending to show in the
form. my problem is when i go to add new rates it puts
them at the bottom not in descending order until i close
the form and go back in then they are in descending
order. is there code or some way that when i click the
button to add the new rates that it puts it in descending
order at that time

Adter you add the new record, do a Me.Requery. If you're
going to add several records, you may prefer to have a
separate button for the requery, since requery reorders the
records and makes the first record current.