Wrong number of arguments or invalid property assignment ??? 1

[williekay]

In the following code I get an error message that reads Compile Error Wrong number of arguments or invalid property assignment, do you know why? It is set to a button click in a sub form to update a linked mainform record.



DoCmd.RunSQL "UPDATE MoldList SET Rework = IIf(Forms![MoldList]![MoldHistory1].Form![SCRAPPED] = 0,NULL, Date()) , Notes = IIf(Forms![MoldList]![MoldHistory1].Form![SCRAPPED] = 0,NULL, Forms![MoldList]![MoldHistory1].Form![Reason]) ,[LastRepair] = Forms![MoldList]![MoldHistory1].Form![LastRepair] , [DL] = Forms![MoldList]![MoldHistory1].Form![DL] , [DLn] = Forms![MoldList]![MoldHistory1].Form![DLn] , [DO] = Forms![MoldList]![MoldHistory1].Form![DO] , [DOn] = Forms![MoldList]![MoldHistory1].Form![DOn] , [CL] = Forms![MoldList]![MoldHistory1].Form![CL] , [CLn] = Forms![MoldList]![MoldHistory1].Form![CLn] , [CO] = Forms![MoldList]![MoldHistory1].Form![CO] , [COn] = """ _
& Forms![MoldList]![MoldHistory1].Form![COn], [Aln] = Forms![MoldList]![MoldHistory1].Form![Aln], [AO] = Forms![MoldList]![MoldHistory1].Form![AO], [AOn] = Forms![MoldList]![MoldHistory1].Form![AOn], [Length] = Forms![MoldList]![MoldHistory1].Form![Length], [Lengthn] = "" _
& Forms![MoldList]![MoldHistory1].Form![Lengthn], [Mold] = Forms![MoldList]![MoldHistory1].Form![Mold], [Plate] = Forms![MoldList]![MoldHistory1].Form![Plate], [PlateSize] = Forms![MoldList]![MoldHistory1].Form![PlateSize], [Type] = "" _
& Forms![MoldList]![MoldHistory1].Form![Type], [Location] = Forms![MoldList]![MoldHistory1].Form![Location], [0] = Forms![MoldList]![MoldHistory1].Form![0], [00] = Forms![MoldList]![MoldHistory1].Form![00], [1] = Forms![MoldList]![MoldHistory1].Form![1], [2] = "" _
& Forms![MoldList]![MoldHistory1].Form![2], [3] = Forms![MoldList]![MoldHistory1].Form![3], [4] = Forms![MoldList]![MoldHistory1].Form![4], [5] = Forms![MoldList]![MoldHistory1].Form![5], [6] = Forms![MoldList]![MoldHistory1].Form![6], [7] = Forms![MoldList]![MoldHistory1].Form![7], [8] = "" _
& Forms![MoldList]![MoldHistory1].Form![8], [9] = Forms![MoldList]![MoldHistory1].Form![9], [10] = Forms![MoldList]![MoldHistory1].Form![10], [11] = Forms![MoldList]![MoldHistory1].Form![11], [12] = "" _
& Forms![MoldList]![MoldHistory1].Form![12]
WHERE [Mold#] = " Forms![MoldList]![MoldHistory1].Form![Mold#] & """



Willie

 

[Remou]

I have answered this in your previous post
How do you continue a SQL DoCmd to the next line
thread702-1306300
If the reply does not suit, please say so. Thanks.