Order feilds in Table

[Ragnar78]

Hy,

I have a Macro that insert feilds in a table depending on the first Field.
So for example If i have:

C048
C048
C049
C064

the macro will add 2 more lines:
C048
C048
C049
C064
C049
C064

Ordering this table should give me
C048
C048
C049
C049
C064
C064

Now i want the table having it Ordered by this field withouth having to create a Table query that specificaly order this table...is it possible through a macro?
Thank you

 

[bat17]

in Code it would be something like
CurrentDb.TableDefs("MyTable").Properties(13) = "MyField"
This works in A97 but I have not tested it on any other versions.

it is not usualy a good idea to let yopur users into tables though, they break things!

peter