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...
Bookmarks