Autonumber from Form

[Guest]

Hi All,
I am trying to create a form that will allow users to add a new record with
an autonumber displayed for the current record they are adding. So starting
with 001, 002, 003. After those are entered and the user wants to add a new
record, it would say 004. Any way of doing this? I searched the forum, but I
don't see how the solution would be applied to a form. Please advise.

 

[Peo Sjoblom]

What kind of form, is this a sheet made look like a form or are you using a
form created through VBA?

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

Btwe, don't search forums, use Google groups

http://groups.google.es/advanced_group_search?q=group:*excel*&scoring=d&lr=lang_en&hl=en

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[flummi]

If you can incorporate a cell into your form you can do this:

Provided your lines entered are in A1100 and your running number is
in A1:

Use a cell somewhere say Q1 which will hold the next number to use:
=max(A:A)+1

Hans