On the Fly Sort

  • Thread starter Thread starter RICHARD BROMBERG
  • Start date Start date
R

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?
 
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.
 
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
 
Back
Top