Assign Number Automatically

  • Thread starter Thread starter S
  • Start date Start date
S

S

Table called Entries

Fields
Entry #
Catagory #
Routine Name

Update button to sort the records by catagory #. then input box asking what
# to start with. I input 001. Then it would go to next record and
automtically update the Entry # to 002. Then the next 003.

etc etc.

Can any one help with the code for update?
 
What determines the "next record"? It has to be something other than the
order in which the records appear when you open the table.
Once you have decided the criteria for ordering the records you can create a
query that sorts appropriately. Once this has been done you can use one of
the following techniques to number the records:
http://allenbrowne.com/casu-10.html

If you wish to assign an incrementing number as the record is created that
can be done as shown here:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
 
Back
Top