update two columns

[2Plan]

I'm trying to update two columns but I get a syntax error.
Can someone tell me what's wrong with this syntax? What's the syntax to update two columns?

Thanks.

DoCmd.RunSQL "UPDATE MasterProjectCodes SET (UniqProjCode, UniqProjName) = (3000, 'APC')" _
& " WHERE CommProjCode='320-301' And CommProjName='SAG-Service';

 

[jrbarnett]

DoCmd.RunSQL "UPDATE MasterProjectCodes SET UniqProjCode=3000, UniqProjName='APC'" _
  & " WHERE CommProjCode='320-301' And CommProjName='SAG-Service';"

John

 

[2Plan]

Thanks.