Hi! I'm working on a particular database that requires identification codes for several of its objects. The first part is generating an ID for a project which will be of the form YY-######. For Example, the first project of the year 2012 would be labeled 12-000001. I know that I could possibly have two seperate strings and concatenate them through vba but I'm not sure how to make this data an actual field rather than just an unbound text box. On top of the project identification code, there are up to 6 different types of reviews associated with a single project that should be label in a similar manner as the project. The six types of reviews are types such as: Building, Mechanical, Electrical, etc. and each of these have prefixes added to the project identification code that they are associated with. For Example, there is a mechanical review for the first project of the year 2012, the identification code would be M12-000001. Is this possible? The extent of my VBA knowledge is coding unbound text boxes. It would be much appreciated for as much descriptive help as possible... I'm in great need of this at work. THANKS!