I want to have Access generate a number that includes: a) an Acquisition Number, provided by the parent form; and b) a sequence of numbers for Conditions – 01, 02…, 11, 12, etc.. The number, to reside in a subform, will look like “9147.01” where 9147 is the Acquisition Number and .01 is the first of several possible conditions.
Do I have to originate VBA code? Can I get a few pointers or suggestions?
Do I have to originate VBA code? Can I get a few pointers or suggestions?