Okay...I used the answers above to get my form to sequentially number. The numbering worked great! The problem I'm having now is that I have a master file of our invoice that several people will access each day. When I mouse over the number and it changes, I am saving the file as theInvoice Number and that's working well, too. But the problem is with the master file. It doesnt' retain the last number used, so that is a problem. Max Wyss (answer above) furnished a code in his answer to help with this, but I couldn't get it to work. I'm not very experienced with this, so I probably did something wrong. I really need this to work, so if anyone can help me, I would greatly appreciate it. What I need is for the form to sequentially number, be saved and the master form to retain the last number so when the next person opens the master file, the last number is there and it updates to the next number. One more thing, I was advised to make the field a read only field, but when you save the master file, then go back in, the number won't change unless you take the read only off.
Thanks in advance for your help. This s a great resource for someone like me.