I need more information than that to help you. Did you follow the instructions from the video exactly? I can tell you changed things up, because I don't name things like txtPassword. LOL

when i step through the code it works but when i take step through off it doesn't work.

That's crazy. No reason I can think of for that to change the behavior. Run down the Troubleshooter. Maybe an Office Update will fix it. I just drove myself nuts on the Zoom problem trying to figure out what was wrong with my database and it turns out it was a known Access bug. Microsoft released a fix for it a week later.