On the Fly Sort

[RICHARD BROMBERG]

I'm using Access 2000 and have a table sorted on the FNAME field
ascending.
I would like to change it to be sorted (under program control) on another
field, for example LNAME field.

Can this be done without opening the table in the design mode?

 

[Glen SIdelnikov]

Use query to the table and sort by any field or fields combination...
Ideally, it would requier some indexing work on the table, but if the table
is small - disregard.

 

[RICHARD BROMBERG]

I used a query to sort the table and that worked fine, but when I created a
combo box based on the query,
it didn't work right. The dropdown list in the combo box is not in the
sorted order.

Any Suggestions ??

Dick Bromberg