I am creating a form that will pass the data to an Access database. I want
the form to have a unique ID number field that is automatically created when
I submit the form. I would like the number to be of the format
200512141,where the first 8 numbers are the current date, and the last number
starts at 1 and each new entry increments by 1. Any ideas on how to
accomplish this?

Thanks in advance.

What platform is your web server?
Why in the form? Depending on your page and form submittals using the form
for this type of identifier could lead to end-user modification. It may be
better to do this on the server. I've done a lot of this type of task for
various projects. Its not a "here's how its done" code snippet. If you want
to talk turkey to hire it out I'm all ears...

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/


"Stumorc" <(E-Mail Removed)> wrote in message
news:6F887A3A-643C-4E2E-BD7F-(E-Mail Removed)...
>I am creating a form that will pass the data to an Access database. I want
> the form to have a unique ID number field that is automatically created
> when
> I submit the form. I would like the number to be of the format
> 200512141,where the first 8 numbers are the current date, and the last
> number
> starts at 1 and each new entry increments by 1. Any ideas on how to
> accomplish this?
>
> Thanks in advance.