put records in descending order

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
Dan said:
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.
 
Back
Top