automatic add number in form field

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?

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.


--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"hermie" wrote in message
...
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?