Hello,
I have created a test file that I hope to implement in an inventory database. Everything seems to be working as it was designed, except when you use the "add or replace equipment" function. For some reason when you input the required information and click "replace", it deletes the "search", "show all", and "click here to add new equipment" buttons on the main sheet. It seems to have to do with their location on the sheet because if I move them to a different spot, this does not occur. After mulling over the code for hours, I still cannot figure out why this is happening.
Any help would be greatly appreciated. Please see the attached file...
Bookmarks