I have a subform with a field that is type autonumber. I want the value of this field to increase by 1 for each row but when a new record is started I want the number to return to 1 and start over again the autonumber data type doesn't seem to function that way, I get ever increasing numbers. Is there another function I can use to accomplish this?