I've done this type of thing before by storing the "last invoice
number used" in a hidden cell, or in a cell that is formatted to
display white font on a white background (that is to say, invisible).
The tricky part is: you need an event or trigger that updates the
invoice number on your form with "last number used plus one", and then
saves the new number as last number used. I have successfully used a
print macro to do this.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.