I have developed a Document Manager for my company. It seems to be working pretty good, but I recently realized one feature that it should have.
The document numbering conventions are in the form of XX-YYYYYY-ZZZZ, where XX is a Document Category selected from a dropdown, YYYYYY is a sequential number, and ZZZZ is a Document Type selected from a dropdown. The user currently enters information about the document including the document number into a User Form and that information is placed in a Table called DocumentData. The feature that the Document Manager needs is the ability to look at the DocumentData table and provide the next available sequential number (YYYYYY) for documents that have XX = ST.
Can someone help me with the code to achieve this.
Thank you