Is it giving you a runtime error? If not then you may want to save your work and close out of access and reopen. I changed all of you variable and ran the code fine. If you continue to have problems, you will need to look at the form fields you are referencing as possible errors.
This is how...