AutoIncrement a string

[Lorlai]

I have a form that takes input from a user (name, description, etc) to store into a table for later use. I am trying to create a hidden textbox that will incorporate some of the user input to create an ID. The user will input the Track (selected from a combobox). The ID number is composed of the following: [Track]_BSxx, where xx is an incremental number that will increase by 1 for each new name within the Track.

HR_BS01
HR_BS02
IT_BS01
ACT_BS01
ACT_BS02
etc.



Is there a way to auto increment the xx portion of the ID number based on the most recent number on the track? Currently, I have the default value of the IDnumberTextBox set to: =[Track] & "_BS", but cannot figure out the end portion.


Any help is greatly appreciated!

[orange]

You seem to be building a lot of intelligence into a code/identifier. Have you really considered using separate fields for separate facts? I've seen a lot of good intentions breaking down when some "definite, everlasting thing" changes for some "it should never have happened" reason.
What does the _BS represent?

Here's an article on atomic fields and values - it's worth the read.
http://forums.aspfree.com/attachment...2&d=1201055452