VBA Runtime Error 3075 when executing SQL update

[G1ZmO]

It worked! I had this version earlier and the only difference is one set of brackets. Why does VBA need to be so 'brackety'!

Now to get it to use the variables from the form..

Thanks Minty (though I might not be finished quite yet lol)

UPDATE ((Item INNER JOIN Job ON Item.JobID = Job.ID) INNER JOIN MakeAndModel ON Item.MakeAndModelID = MakeAndModel.ID) INNER JOIN ItemType ON MakeAndModel.ItemTypeId = ItemType.ID SET Item.JobID = 8861
WHERE (((ItemType.ItemCategoryID)=13) AND ((Item.JobID)=9507));

 

[G1ZmO]

I have now finished the form which is working perfectly.

Thanks for all your help Minty

 

[Minty]

Glad you sorted it. Good luck with the rest of your project.