The MS Access Error Code ‘3086’ issue

Hello TechyV buddies!

DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)

and (LINKED_TABLE.item3 = Forms!frmItem3!DateField)); Only solution I find is moving INNER JOIN clause to new line (HEX (0D 0A)) as follows: DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE

INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)

and (LINKED_TABLE.item3 = Forms!frmItem3!DateField)); Then I SAVED the query and I ran the query and it works fine. After I close the MS Access apps, when I re-launched the access, the syntax shows the old format (new line shifted back to the old line as HEX(0D 0A) disappeared) as follows: DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)

and (LINKED_TABLE.item3 = Forms!frmItem3!DateField)); I am having some problem on MS Access. I am using Windows 7 and MS Office 2010. The error happens when I use MS Access. The error also appears in the later version of Office and windows XP. The error code is this: : 3086

DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)

and (LINKED_TABLE.item3 = Forms!frmItem3!DateField)); Only solution I find is moving INNER JOIN clause to new line (HEX (0D 0A)) as follows: DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE

INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)

and (LINKED_TABLE.item3 = Forms!frmItem3!DateField)); Then I SAVED the query and I ran the query and it works fine. After I close the MS Access apps, when I re-launched the access, the syntax shows the old format (new line shifted back to the old line as HEX(0D 0A) disappeared) as follows: DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)

and (LINKED_TABLE.item3 = Forms!frmItem3!DateField));

This error only happens when I start MS Access and this sometimes works fine and sometimes it also fails.

And another problem is my internal SQL syntax always changes every time MS Access is opened.

Can anyone help me solve this issue?

I will really appreciate the effort in solving this issue.

Thank you!