>Is there a simple way to sort a table when opening a form? I would like to sort the form alphabetically with a field index when opening this particular form. The form allows you to parse through the entire table with back and forward buttons, but it is sorted based on the order in the table instead of alphabetically.

Use SET ORDER TO tag myTag command to set specific order on the table.