sequential numbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top