I'm building an Access 97 app that has one form that will be used as 

a "view only" screen. The bugger is that the data comes in sorted 

alphabetically automatically by user name. I've tried to get it to sort by 

a key number (user assigned) so the end user can look at the records by 

that key number. I've sorted the data in the table by the key number & it 

still does no good. I wrote a qry to fire off as the form loaded, but you 

can tell what good that did.



Any tip??



Thanks!!



Sean

You say you wrote a query to fire as the form loaded. Did you build a

query sorting on the field you want and base the form on that query

instead of the table? That should work. Change the RecordSource property

of the form to the query. Your other option is to set the RecordSource

property to a SQL statement: "Select * FROM YourTableName ORDER BY

YourKeyNumber Field" (Do not put the quotes in if you are putting this

in the Recordsource property in the property sheet.)





>I'm building an Access 97 app that has one form that will be used as 

a "view only" screen. The bugger is that the data comes in sorted 

alphabetically automatically by user name. I've tried to get it to sort

by 

a key number (user assigned) so the end user can look at the records by 

that key number. I've sorted the data in the table by the key number &

it 

still does no good. I wrote a qry to fire off as the form loaded, but

you 

can tell what good that did.<





Hope this helps,



Richard Lobel

Accessible Data

richard@a... <mailto:richard@a...> 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx