A small group of users want to create a form which increments the Quote
number only after they click a control button named cmdSaveQuote to avoid
losing Quote numbers if a user decides to cancel out of a quote. It is a
responsibility 1-2 people will share, but only 1 person at a time will be
responsible for the quotes, so very little code needs to be in place to avoid
duplicate quote numbers
Unfortunately, I've only scratched the surface for macros and vbs coding.
Any help would be greatfully appreciated.
Thanks in advance,
Charlie
Doug Robbins - Word MVP - 15 Aug 2006 20:52 GMT
Use a variation of the code in the article "Creating sequentially numbered
documents (such as invoices)" at:
http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm
In a macro named FileSaveAs

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
>A small group of users want to create a form which increments the Quote
> number only after they click a control button named cmdSaveQuote to avoid
[quoted text clipped - 10 lines]
>
> Charlie