First one question, that field is field that you want store in a record set or not.
If is a field of the record set you can define as autonumeric with format
like tell you justin_tighe but in the design of the table:
This can work depent of your problem....
Originally posted by koko
how can I Use the AutoNumber Until the end of the year, and it will reset to 0 for the new year?
To apply the format use the format property of the control and just type in 000000 - this will format that control. If you press F1 when on the format property you will get help on the all the format commands you can type in.
to reset an auto number you need to use an insert query to insert a new record forcing in the number you want. If your autonumber is the primary key or is an unique index you wont be able to do this as you cannot have duplicate numbers