Filter by Form field dropdown

[Guest]

When using filter by form in an autonumber field, clicking the customer
number (an autonumber) field and using the drop down arrow on the right, the
customer numbers appear but the numbers are out of order. Is there a setting
to put the numbers in consecutive ascending/decending order?

 

[Jeff Boyce]

The Microsoft Access Autonumber data type is designed to be a unique
identifier, nothing more, and is generally unfit for human consumption (say,
as a ?!consecutive sequential number?!).

If you want to see something in order, you'll have to tell Access to sort by
that field. One way to do this is to do so in a query behind the form.
First create the query, sort by the field you want, then base the form on
the (sorted) query.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/