Vern -

>>This may not solve the problem but I always change the RowSourceType to 0 and then back to it's original setting if I'm doing anything with the RowSource.

I am getting the same behavior with comboboxes and listboxes. Syntax Errors which can be resumed without being errors. They can also be stepped-through in the TRACE window without problem.

Did changing the rowsourcetype to 0 then changing it back to 6 prevent all future occurrences of the dreaded "Sytax Errors"?

- George Mamunes