sorting while adding new records

[Guest]

My form sorts just fine in decending order by CallID number when it's first
opened. But as soon as the user starts entering data, the new records are
added to the end of list until the form is closed and reopened. Is there
anyway to get the new records to sort correctly immediately, rather than
having to close the form & reopen it?

 

[Mike Painter]

My form sorts just fine in decending order by CallID number when it's
first opened. But as soon as the user starts entering data, the new
records are added to the end of list until the form is closed and
reopened. Is there anyway to get the new records to sort correctly
immediately, rather than having to close the form & reopen it?

All records are appended to the end of the table. You can refresh the
recordset either on the toolbar or in code.

If you are viewing them it is usually better to wait since

 

[Guest]

What would the code be, please? And in what event? On Current?

 

[Guest]

I figured out it's me.refresh, but it still doesn't work.

 

[Rick Brandt]

I figured out it's me.refresh, but it still doesn't work.

Actually you want Requery, not Refresh.