How do I maintain sequence in an Update Form?

[jlwoods1]

My customer database uses autonum to create a unique key so I can add/update.
I have created a query sequencing by name (not a unique key), then a form
build on that query. But I cannot scroll thru the records alphabetically, it
reverts to sequence by the autonum field. How can I allow my users to browse
thru the file (next record / previous record) in sequence by the name?

 

[Douglas J. Steele]

Base your form on a query that has the appropriate ORDER BY clause.

 

[jlwoods1]

Doug - Thanks for your response. The form is based on a query, and the
order-by is on the name field. Still does not allow me to scroll forward/back
using next record / previous record in sequence by the name. Sequence is
still the autonum value (I have that field in the query, but non-display). If
I execute just the query the records are in the correct sequence.
- Jim

 

[Rick Brandt]

Doug - Thanks for your response. The form is based on a query, and the
order-by is on the name field. Still does not allow me to scroll
forward/back using next record / previous record in sequence by the
name. Sequence is still the autonum value (I have that field in the
query, but non-display). If I execute just the query the records are
in the correct sequence. - Jim

Then your form must have an OrderBy property set that is overriding the sort of
the query. Just remove that.