Syntax error (missing operator) in query expression - Access 2010

[MeaganN]

Hello

I am getting the following syntax error (missing operator) in query expression on the below query. I have rewritten the query several times, all my table names and pathways are correct and I am at a loss as to the error in the below code:

Me!ProductName.RowSource = "SELECT DISTINCT [Register of Raw Materials].[Product Name].Value" _
& "FROM [Register of Fibre Suppliers]" _
& "INNER JOIN [Register of Raw Materials]" _
& "ON [Register of Fibre Suppliers].ID = [Register of Raw Materials].[Supplier Name]" _
& " IN '\\pmtwfp0001\public\AP PUBLIC\Chain of Custody Systems\AFS CoC Database\Test_be.accdb'" _


& "WHERE [Register of Raw Materials].[AFS Risk] Not Like 'Significant' AND [Register of Fibre Suppliers].[Supplier Name]='" & Me.Supplier.Column(0) & "'"
The query is in an Access 2010 database and is an "After Update" event. Any help to solve this error would be much appreciated

Thanks Meagan

[June7]

Need a space at the end of each line before the quote mark so the text doesn't run together when the statement compiles.

Don't need .Value because Value is default although don't think it hurts.

Also probably doesn't hurt but LIKE is not really useful without wildcard. Use <> instead of Not Like.

[MeaganN]

That's for replying so quickly and for your advice.
I am no longer getting the syntax error however I am receiving the following message instead "Cannot reference a table with a multi-valued field using an IN clause that refers to another database".
I have tested the query with and without the .Value and still get the same message. I have also used .Text as the field that will be selected from the relevant table is a text field.
Any further suggestions?

[June7]

The message says there is a field set up as a multi-value. Text or number, it can still be multi-value. I NEVER use multi-value fields.