Form Numbers Automatically Increment by 1 Upon Opening

[GVDLS]

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]

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

 

[Gord Dibben]

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