I too have that error message pop up.  I have researched the syntax error problem on your forum and found nothing applicable and I will go back like Brent did to find where I made an error.  I was just curious if you folks had a chance to research this issue and had any results.  Thanks for your continued time and patience with us who struggle a little with some of the intricacies of Access.