Sorting records in form view

[Guest]

Hello, I need to be able to sort the underlying records by a variable
(TableName). I have tried simply going into the table, sorting on that
column and saving it. But, when I open up the form, the records do not
reflect the sort order I just imposed on the 'TableName' field.

'TableName' is not the first column of the table. Must it be the first
column to be able to see records in form view in that order? I need to be
able to see records ordered by this 'TableName' field to perform numerous
edit checks on my record set.

Thanks.

 

[Granny Spitz via AccessMonster.com]

Hello, I need to be able to sort the underlying records by a variable
(TableName). I have tried simply going into the table, sorting on that
column and saving it. But, when I open up the form, the records do not
reflect the sort order I just imposed on the 'TableName' field.

Create a query based on that table and sort on the TableName column, and use
this query as the form's record source.