How to apply a newly sorted table to the attached form

[SoClueless]

I changed the orders of columnns in a table in order to perform a sort by last name, then first. How can I fix it so that the records will reflect the new sort in the form we use to enter the data? It took the last name sort, but not the first name. Thank you.

 

[Lightning]

Open the form in Design View. In the Form's Property Sheet, enter the Names of the Fields you wish to sort by IN THE ORDER YOU WANT TO SORT BY, in the ORDER BY property. If you wish to sort in ascending order, that is all you need to to. To sort in Descending order, add DESC after the field names.

For more information on the Order By property, check out the ORDERBY topic in the on-line Help.

HTH
Lightning

 

[SoClueless]

Thanks again Lightning!