Custom Auto Number (somewhat complex)

[pjd71]

Getting more and more dangerous with creating databases. This is the new sticking point I am on and please understand that I am still learning VBA (figure out what commands do what). I have created a Fiscal Database and want to create a custom ID Auto number.



I would like the ID number start with FCP, the Fiscal Year (comes off of field of form), Fund Control Point (comes from the form) and a 4 digit auto number (to start with 0001).
Example: FCP-2013-021-0001

Of course, this number gets stored to the Table and the ID number is generated/viewable (Un-enabled) in the form when information is entered into the form.
The Fund Control Point is a combo box within the form and does auto populate some other fields within the form.

Thanks in advance!

[RuralGuy]

See if Paul's code helps a bit: http://www.baldyweb.com/CustomAutonumber.htm