hi eric,
so this is the wada recordset. could you tell me where i would add in the code you gave me to produce the username from userid that you gave me earlier.
i managed to do it with new recordset but if it is better to do the way you said could you guide me on the existing recordset?
SELECT ClientID, ClientUserID, Title, FirstName, LastName, DateOfBirth, Email, Address, Address2, City, State, Zip, Country
FROM clients
WHERE ClientID = ParamClientID OR ( -1= ParamClientID2 AND ClientID= ParamSessionClientID)
many thanks