Hi Pat, Thanks for chiming in! I hope you're doing well.
What I was trying to accomplish is a mute point. I fixed my data with an update query, I was attempting to be able for a user's mistake to be corrected with code. Instead I ended up writing the code to keep them from making the mistake...