Syntax error (missing operator) in query expression

[1griffa25]

Morning all
The problem whihc i have is that, when trying to open the form "Create Timetable", through the switch board.... a message box appears saying "Syntax error (missing opertor) in query exprssion"
Any ideas on why it is showing this message box???
Help would be appricated
Thank you

 

[burrcm]

Does this only happen when you open with the switchboard, or also when you open directly in the database window? If only the switchboard, it may be corrupt. Recreate it. If also in database window, do you have an on open event? Something is wrong here.

Chris B

 

[ajetrumpet]

Is the form based on a query?? If it is, check the syntax of that query.

Does the form open even though you get the message??

If there is any Visual Basic code associated with the form?? If so, check any SQL that is a part of it.

 

[selvsagt]

Its probably a queryproblem.
Check the datasource for the form. Se if you have any expressions in the query thats missing a ( or a [ or something like that.

Example: Field: ([field1+[field2])/2