auto number (letters-YY0001)

[wshs]

i've created a new field "txtprNum"
this number needs to be in a such format; whs-yy0001
so whs- is always the same and then yy = this year (05)and needs to change to (06) next year, and then 0001 + 1 everytime new record is added.
is this possible in vba?
so when user opens a form, this field is automatically given a number. first it'll be whs-050001.
and then when you add another record, it'll be whs-050002.
im sure there is a way to do this on form open event.. or else.. any help will be appreciated..

 

[PHV]

Provided you'll not have several users creating records at the same time you may consider the DMax function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MichaelRed]

see faq700-184



MichaelRed

 

[wshs]

thx but i don't understand...