Help changing default Sort Code

[Cevelctq]

I am trying to set the default sort code to something other than the primary key. Example- Book Code is Primary Key but I want the table to be sorted by Title. I have went into properties and used the Order By property and typed 'Book.Title' however when I view the datasheet, Book Code is still the 1st column??? Is it still being sorted by Title??

Any help would be greatly appreciated

 

[trucktime]

Sort

The proper way is to base forms and reports on queries and sort the records in the query. In the query grid you can sort one or more fields ascending or descending. You can also ad a column (for instance combine two or more fields, or format a field) and sort on that.

 

[Cevelctq]

Thanks, that helped me figure it out