Auto Number Using a Field and Letters

[dgutsche]

Okay I have asked this question in other forms and forums before but haven't come up with an answer that works. The big issue is wanting to create the following records in a subform every time a new record in the subform is added. I can populate the Ticket field and know how to cast fields as strings to append them (so I can get the Cylinder field). The output is used to populate a table called Cylinders. My question is:

How do I create a field of letters (or numbers) corresponding to the row in the subform without continuing from the previous letter (or number) in the Cylinders table?

Ticket	Letter	Cylinder
1589	A	1589A
1589	B	1589B
1600	C	1600C
1600	D	1600D
1600	E	1600E

[ranman256]

If the master record Ticket = 1600
you'd need a NEW button to add new record.

vLastLettr  = Max([letter],"tSubTbl","[ticket]=" & txtTicket)     (to get the last letter
vNewLetter = chr(asc(vLastLettr )+1)
[LETTER]=vNewLetter
[Cylinder]=[ticket] & vNewLetter

[June7]

Answered in earlier thread https://www.accessforums.net/program...orm-46475.html