Customizing Autonumber

[escaflowne_moon]

I don't know where this applies to which category since it overlaps in a way.

How can I customize with VB codes for an autonumber which is the primary key called "FileNumber" This number consist of AUD-001 in this format..but there are different divisions so there could be PAY-001 depending on the division..how can I write a code that will generate this automatically like a autonumber in sequences. I don't know if this can be done.

 

[Bodisathva]

if the prefix is irrelevant to the number, i.e. if you have AUD-001 you cannot have PAY-001, you can create the primary key simply by concatenating the pieces you require along with a record count:

recNumber = DCount("*",table,"1") + 1
pKey = strPrefix & "-" & Format("000", recNumber)

if you can have both AUD-001 AND PAY-001:

recNumber = DCount("*", table, "pKey LIKE (" & strPrefix & "*)") +1
pKey = strPrefix & "-" & Format("000", recNumber)