Can anyone tell me the correct way to represent this.

I have an sql statement that needs to send a value to a database table but put it the field of the recordset where the username is stated.

heres what i have:

dbCommand.CommandText = "INSERT INTO Players where ((First_Name = sfirstname) and (Last_Name = sSurname)), (Level3Score) values (level3score) "

what i want is the level3score stored in the field Level3Score in the recordset where the users first and second name equal that of the current user.

any ideas please, jon

"INSERT INTO Players (Level3Score) Values (" & level3score & ") WHERE ((First_Name = '" & sfirstname & "') And (Last_Name = '" &  sSurname & "'))"

____________________________
multi-tasking - the ability to hang more than one app. at the same time.