Hi,

Can I get a id field to equal the first character of their first name,
3 characters of a users surname follwed by 2 numeric characters.

The first bit I guess I would achieve by something like this

id1= lef(UserForm.txtsurname, 3)

but the second one I would like to be incremented but the number of
people who share the surname. ie.

john williams = JWILL01
jane williams = JWILL02
Gary williams = GWILL01

so on.

Is this possible


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=468946