how to specify an index for command buttons on a form?

[WayneC]

I have a form to view and update a table (find, next, prev, change, and add
buttons).
All these buttons seem to use the record number primary key for the table.

Can I set the entire form, or these command buttons individually to use a
specific index?

 

[John W. Vinson]

I have a form to view and update a table (find, next, prev, change, and add
buttons).
All these buttons seem to use the record number primary key for the table.

Can I set the entire form, or these command buttons individually to use a
specific index?

You can (and should!) base the form on a Query sorting the data into whatever
order makes sense for your application, rather than directly on the table.
This sort will make use of an index on the field or fields used for sorting,
if there is such an index, but you don't need to (and can't!) refer to the
index in the query.