Really Easy, what am I doing wrong

[JTQ911]

On a form, I have a text box linked to a field in a table. So as you use the arrows on teh bottom left of teh page, you scroll through the fields in the table. In my table, I have the records sorted numerically in ascending order....... why is the textbox, which is linked to this table, as you scroll through using those arrows on the bottom left of the page, not showing the records in numerical order as well. In my table as you go down the field "Units" from 1-20. In the text box which is linked to the table field "Units", if you scroll through using hte arroow, it goes 1, 2, 30, 27, 4, etc etc etc. Thanks inadvance.

 

[Fernando]

Have you check the Form's module property OrderByOn? if not set it to True

 

[JTQ911]

Lol, where the heck is that????

 

[boblarson]

You also have to realize a couple of things:

1. Tables in Access do not really store data in any meaningful order. They will display an order if given an order to display it in.

2. If you have a text field that is numbers, it will sort it in what is known as Military sort order. All first digits are sorted from the left first and then the next ones over, etc. So, you would have
1
10
101
102
103 etc
11
12
13
14
15
16
17
18
19
190
191
192
1993
1999 (etc)
2
20

 

[Fernando]

Yes, if you want to have it in the order 1,2,20,30,4001 you will have to have that field (fldNumber) as a Number Type so what boblarson said wont happen.
You will have to create a Query of the table and on fldNumber Sort: Ascending and then Link the query to your form insted of the table.