New Record Auto ID Coding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey guys, I'm trying to create an automatic Form ID number. However I just
changed my form to not allowing people to edit the form and my previous
coding was using the CurrentRecord number along with the current Date. Is
there a way to code each form based on what record number it is along with
the current date... something like this:

CurrentRecord-Date()

So the first record for today would be

1-06192007

Then

2-06192007
 
Hey guys, I'm trying to create an automatic Form ID number. However I just
changed my form to not allowing people to edit the form and my previous
coding was using the CurrentRecord number along with the current Date. Is
there a way to code each form based on what record number it is along with
the current date... something like this:

CurrentRecord-Date()

So the first record for today would be

1-06192007

Then

2-06192007
Click to expand...

Since Access doesn't contain or use "record numbers", I'm assuming that you
have some field in your table which contains this value. What is the structure
of your table? What is the recordsource of the form? If you don't allow edits
using your form, how DO you add or edit records?

John W. Vinson [MVP]
 
Back
Top