force the auto number to change according to the filter applied on the table

[John-n]

hi i have a table and it is like this 1 a 2 b 3 f let's assume i want to add new data {C} so it will be like this 1 a 2 b 3 f 4 c is their any way i make the table look like this 1 a 2 b 3 c 4 f can i force the auto number to change according to the filter applied on the table is their a numeric field can be used instead on auto number that can be changed according to the filters

[John_G]

If you are really using an automumber field, then no, you can't change it. All autonumbers really do is give each record in a table a unique ID number, and they should not really be used for anything other than that.

In your case, I don't see what the issue is anyway; all you need to do is sort on the second field and you will have what you want.

Am I missing something?

John

[John-n]

thanks for your reply John can i use a another kind of numeric field rather than auto number i have built my data base depending on a numeric field but auto number won't help me specially when i will add new data to the base so i need a numeric field that will remain the same no mater what the filter i apply on the table is this possible there is an example on how i am using the auto number field

[John_G]

"i need a numeric field that will remain the same no mater what the filter i apply on the table"

I think you are misunderstanding how autonumber works. Autonumbers (real ones) do not change once assigned; they remain the same regardless of the filter or sorting applies to the table or form. Autonumbers are called that because they are generated automatically by MS Access, and are useful because they are guaranteed to be unique within each table. and they cannot be changed. They should not be mistaken for a "record number" - there is no such thing as "record number" in Access.

With regard to your original question - can the autonumber be made to change according to filter or sort order - No. Is ther another numberic that can be made to change according to the filter or sort order? Again No, not without using VBA.

HTH

John

[John-n]

thank you very much for your answer John can you help me with the Vba code (: