I have report where in macro is used DynamicUpdateCommand
for i=0 to 3 if Teams(i,1)>0 then sSQL="update [Standings A] set Points = "&Teams(i,1)&" where Team_ID = '"&Teams(i,0)&"'" ''msgbox(sSQL) set UpdateAction = ActiveDocument.DynamicUpdateCommand (sSQL) end if next
When I run this macro (on button press) macro edit windows appear with this line selected and there is no error messages. On 2 other computers this macro works fine.
I found that there is parameter 'Enable Dynamic Data Update', but it's checked on all computers