Hi there. This is what I am trying to achieve:

I have a form for adding details of users which I need to automatically give a 'USER ID' from the surname + first name + random number of 0-9.
Under 'default value' for the field that will generate the User ID I have :

"Me.(Surname)" & "Me.(First Name)"
Obviously I am using the correct field names and NOT SURNAME OR FIRST NAME !!!!!

This string just does not work !
Can anybody help me on this one ?

Many thanks,-NLP

For starters, drop the quote marks and brackets and me.:
= [Surname] & [First Name]


[This message has been edited by Chris RR (edited 02-07-2001).]