Sorting field in table

[Lamyatt]

Hi Newbie here,
I have a table that i would like to sort the records in one field Ascending.
I would like for the field to be updated after the record is entered so that the records in the field are all ways in a alphanumerical order
I have put [SSB-CW].Square in the Order BY properties of the table. The Table is called SSB-CW and the field to sort is called Square. As i enter the records they stay in the order entered. When the table has been closed and then re-opened the records are sorted.


Do i need to design a form and set the lost focus property with the SQL [SSB-CW].Square
Simple if you know how i suppose!!!
Thanks

[June7]

After entering new record, the recordset has to be refreshed to enforce the sort order. This applies to table, query, form.

[Lamyatt]

Hi June7
Thanks for the quick reply. Could you please advise how to refresh the recordset after the last field loses focus or exits
Thanks

[June7]

Click the Refresh button on toolbar.

From form can use code in some event. Trick is figuring out what event.

Be aware, Refresh or Requery action will set focus on the first record.

Why is this sort order important?