Form Numbers Automatically Increment by 1 Upon Opening

Thread view:

Thread rating:

GVDLS - 02 May 2006 19:51 GMT

I need to have the form number on the form increment by 1 when the form is
opened by another user on the system.

pdgood - 02 May 2006 20:42 GMT

I'd like to know how to do this also if anyone would care to share their
knowledge. I assume it would take VBA.

Signature

pdgood

Gord Dibben - 02 May 2006 21:22 GMT

Have a look at John McGimpsey's VBA method.

http://www.mcgimpsey.com/excel/sequentialnums.html

Gord Dibben MS Excel MVP

>I need to have the form number on the form increment by 1 when the form is
>opened by another user on the system.

Gord Dibben MS Excel MVP