Form Load Error described as "Syntax Error (Missing Operator) in query expression"

[pckong]

Form Load Error described as "Syntax Error (Missing Operator) in query expression"

Hi guys,

I made some changed in query integrated in a form. The form will load up with automatic query run on open. The problem is my change has some syntax error. After a few unsuccessful run, the error code seems store somewhere in the query. I removed the problematic code, but the error is still there, like it is stored in the query again.

Form Load Error described as "Syntax Error (Missing Operator) in query expression".

What can I do to reset the query/form to original state?

Thanks
Pete

 

[ct2013]

Re: Form Load Error described as "Syntax Error (Missing Operator) in query expression

Firstly ensure the query opens by itself from the navigation bar, then delete the query from the form and reinsert it into the form and see if this gives more hope.

 

[pckong]

Re: Form Load Error described as "Syntax Error (Missing Operator) in query expression

Thanks for the reply. But it still does not work. I guess it is somewhat related to error handling when I did the coding.