I've attached an example of the application I've been working on for data entry, editing, auto numbering, credential capture, and multiple users. I've pieced this Frankenstein together using all sorts of code found all over the internet, these forums, and other forums (sorry, desperate) as well. I've run into a few minor issues along the way and am in desperate need (told you I was desperate) of finishing this project. There are holes in several places where I've tried all sorts of code to fix it but to no avail.

The biggest problems I'm facing are getting the auto numbering to work, editing to properly work, (The editing would actually create an new item with a new ID to show the history of the item) and credentials (two teams with separate login areas) to be properly captured and passed through the form for output. I ended up going the multipage way but am in no way tied to it. I know my code's not efficient in any way, but I'm a beginner who never read the instructions, lol.

Sorry for the rambling. Again, any help at all is GREATLY, GREATLY APPRECIATED.
Example(Errors).xlsm