Adding review and delete form onto existing Excel database

Hi all,

I created a database on Excel 365 with no trouble. I can input data into the form and when I ask it to, it adds the information into the database and sorts it for me alphabetically.

However, for some reason I haven't been able to create a form that allows me to review and delete data if necessary. The database is for staff, and the rota documents take the information from the staff database to create the rota.

Sometimes new staff come and sometimes old staff leave, so I want a form that means that you can review, edit and delete entries, but that doesn't alter the formatting. So, every time an entry is deleted, the form re-organises itself.

I have attached the current form as it is at the moment, with real names deleted. Is there anyone that can demonstrate the VBA code that will allow me to create a review, edit and delete form to go onto the database?

Hi Fire_The_Torpedo

This will give you an idea...in attached file...Userform1

To edit or delete...select surname from staff surname search...
Can make edits to all controls except surname...Once finished editing press [UPDATE]

To delete a entry...select surname from staff surname search...press [DELETE]

to add a entry....IGNORE staff surname search dropdown....

complete all other boxes and selections and press [ADD]

That is the gist of it...


EDIT...Added a new upload as there was an error in Update Button Code...

Thanks.gif
Remember to mark thread as solved

The only problem I have is that I keep getting a debugging error when I click on the UPDATE button

Hence the EDIt in post 2 where I uploaded a new file...