update macro

[Patchy]

I can't get my update macro button to work. I'm trying to update every Product Model #10 but only if it is in product group AB on the Product table.

Please note the names are correctly labelled...

I have [forms]![UpdateProduct]![ProductGroup] as criteria for Product Model column in my update query and [forms]![UpdateProduct]![upSM] in "update to" field.

UPDATE Product SET Product.[Product Model] = [forms]![UpdateProduct]![upSM] WHERE ((Product.[Product Model]=[forms]![UpdateProduct]![comSM]) & Product.[Product Group]=[forms]![UpdateProduct]![ProductGroup]);

 

[pr2-eugin]

I take you meant to use AND logical operation..

WHERE ((Product.[Product Model]=[forms]![UpdateProduct]![comSM]) [COLOR=Red][B]&[/B][/COLOR] Product.[Product Group]=[forms]![UpdateProduct]![ProductGroup]);

In Access/VBA you use the actual word not the symbol as used in C/C++/Java.. Try..

WHERE ((Product.[Product Model]=[forms]![UpdateProduct]![comSM]) [COLOR=Blue][B]AND [/B][/COLOR]Product.[Product Group]=[forms]![UpdateProduct]![ProductGroup]);