sequential numbering

T

Theresa

I have seen similar questions to what I am going to ask, but they all apply
to queries. I have a table (PurchaseLog) that keeps track of company
purchases, and I want to keep our control numbers formatted the same as the
way we kept them before using Access. Our current format is MF-####. Is
there anyway that when we begin a new purchase entry on our PurchaseLog Form
that the control number will automatically be entered. I would like the
control to start as MF-2990 and continue to automatically count as each new
entry is added. Any suggestions would be appreciated.
 
R

Roger Carlson

You can use the DMax function to look up the highest value stored in the
table and concatenate it with "MF-". On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"AutonumberProblem.mdb" which illustrates how to do this. There is another
called "FormSubform.mdb" with also does this in a subform.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top