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