Hi,
And thank you for replying. I do apologize about the cross posting. I had this problem the other day, but some how resolved it. After adding more code the problem is back.
Answers to questions:
1. Not sure, but I will unload in both now
2. Very good point, I noticed that just after I posted and did not want to make any changes until I saw if I would get a reply. I once made changes to a program I was working on and had posted for help and learned that is not the way to do it.
3. I am pretty sure it is modal. I am new to this so I am not positive.
4. I did not set it to be protected. I tried putting the line of code you suggested in the immediate window but nothing ran differently.
5. I will change my Dim statements.
I have to run an errand now so I will not be able to reply for awhile should you continue to help me. I do appreciate the help and will check back as soon as I can. Thank You