Misleading “Syntax error in JOIN operation”
Hi
I’m getting a “Syntax error in JOIN operation” when switching from datasheet back to form view. The form has a tab control containing several subforms. The error only appears after a particular tab and subform were active before switching to datasheet view. The error occurs after clicking form view from toolbar and before the parent form’s Current event i.e. seemingly before it can be handled. The subform’s recordset is dynamically set by the parent form’s Current event. The SQL syntax looks fine and works consistently with no issue in form view. Switching between form and datasheet view is necessary to the application.
I’ve applied the advice I’ve seen to enclose the “ON” statement in “(…)” but that does not fix this.
I’ve been thinking I need to null the subform’s recordset when the switch to datasheet view occurs, but by then the subform no longer exists (or does it?). The error occurs, even whilst remaining on the same parent record, for which the subform’s recordset was ok in form view, before the switch to datasheet but not after the switch back to form view.
Hope that makes sense.
Hi
I’m getting a “Syntax error in JOIN operation” when switching from datasheet back to form view. The form has a tab control containing several subforms. The error only appears after a particular tab and subform were active before switching to datasheet view. The error occurs after clicking form view from toolbar and before the parent form’s Current event i.e. seemingly before it can be handled. The subform’s recordset is dynamically set by the parent form’s Current event. The SQL syntax looks fine and works consistently with no issue in form view. Switching between form and datasheet view is necessary to the application.
I’ve applied the advice I’ve seen to enclose the “ON” statement in “(…)” but that does not fix this.
I’ve been thinking I need to null the subform’s recordset when the switch to datasheet view occurs, but by then the subform no longer exists (or does it?). The error occurs, even whilst remaining on the same parent record, for which the subform’s recordset was ok in form view, before the switch to datasheet but not after the switch back to form view.
Hope that makes sense.
Last edited: