You need to filter out the current record from the recordset so that someone can update the record to the current one without it counting as "already exists". Just add to the recordset WHERE clause: AND UserID <> uidparam and set the uidparam to the same value you are using to filter and display the updated user data.