automatic add number in form field

H

hermie

Hello I have an data entry form with a field called tasknumber. What I want
to do is that it automatics calculate the tasknumber. It would be something
like this:
find personsname and last tasknumber then new tasknumber = lasttasknumber +1

Hope I explained well my question

Is this possible?
 
M

[MVP] S.Clark

It is possible, but you may not want to do so in a multi-user enviroment, as
duplicates can occur.

I would do it with code, and retrieve the value from a table, that is locked
appropriately.

That, or just use an Autonumber.
 
Top