>Thanks to everyone that responded to my posting. I finally found the source of my problem: I had a combobox where the RowSource was an SQL statement that I set at design time. I didn't notice that the SQL SELECT statement was being truncated in the combobox properties window. So, I moved the setup of that combobox to the form Init method, and the syntax error has gone away.
>
>Do you think that a "SYNTAX ERROR" with no other information in general means that design time properties of a control somewhere are improperly set.
>
Glad you found the problem. Yes, the problems from controlsources usually do not provide any clues with the errors.
If it's not broken, fix it until it is.
My Blog