Add,Search,Edit,Delete via Useform

Hello, could you please help me with this data entry form?

I just want:

1. If user click "Add New PC" button, it will go to frm_add and fill up the form and once user click the "Save" Button it will save in "FTE Sheet"
2. If user click "Delete PC" button, it will go to frm_delete and search the pc name via combobox, and once user click the "Delete" button, it will delete the data and clear the textboxes.
3. If user click "Edit PC" button, it will go to frm_edit and search the pc name to edit via combobox, and once user click the "Update" button, it will update/overwrite the data and msgbox will pop-up "Update Successful".
4. If user click "Search PC's" button, it will go to frm_search, and it will display the data depending on the list of the combobox picked by the user.

Thanks in advance.

Hi abousetta thanks for that.

Just need some changes here, how do i permanently assign sheet1 as the database?

when i try to add a sheet and run the macro, it gives me an error on this line:

Please Login or Register  to view this content.

Hi norie, i've tried your code and now it gives this error line:

it debugs in "c.Select"

Please Login or Register  to view this content.