visible record order

[Fredrated]

When my users open a table I would like the records to display with one field
ascending and another field descending. It is easy enough to create an index
with this property. but the options available when the table is displayed
don't seem to allow this. Is there some way to make the display use an index
to display records when the table is opened?

Thanks

Fred Parkinson

 

[Duane Hookom]

Don't allow them to open a table. They should be opening a form based on a
query. At very least, use a query rather than a table.