Re-order of fields in list box

[newToAccess2010]

Could you point me to sample code which will enable me to re-order records on a form entry? I am using MS Access 2007.

Thank you.

 

[pbaldy]

At its simplest, you change the row source of the listbox:

Me.ListboxName.RowSource = "SELECT * FROM TableName ORDER BY FieldName"