Automatically update existing data using a Update command button

Hi,

I can't seem to UPDATE existing data on my worksheet. The SEARCH and ADD NEW command buttons work great! However, I am creating a monitoring database and I really need the UPDATE command button to work since there will be a lot of changes to the data I previously inputted. Please help!

Heres the current code I have, It works fine for update; However, it doesn't automatically update the data on the worksheet.
You have to SELECT the 'NO.' of the row you want to update...the code I put in was the OFFSET FUNCTION.

Formula:

Please Login or Register  to view this content.

Thats just part of the code! But theres around 40+ text boxes! i just need help on the basic framework of the code! Thank you!!