Search Record - When does a record already exist? When all the cells column A:S are the same as another row?
Just checking in case you have other thoughts.
How do you see this working? Highlight duplicates, Delete duplicates, ....
Do you want a general search of the sheet or search for the values entered in the userform?
Update Record - How do you visualize this. Do you want users to input a row number and then replace that row with the data entered in the userform? Or ...