I"m using a field name in vba the problem is that the name of the field is % Complete, I get a syntax error when I run the code, I have included brackects between them but then the code doesn't recoginze the field name. Help please,\
You have probably thought of this but just in case, for field names I only use a-z letters. Can you change the field name to perccomplete. I do not know how to use a special character in code, but just thought I would mention this, just in case your application is just being developed or is small, changing the field name might be the easiest solution.