UPDATE Issue

[ralphralph07]

Hi

I have a database that i have inherited and i'm getting the an error on the following line of code:

Sub update_system_record()

DoCmd.RunSQL "UPDATE [system values] SET myt!last_num = (current_val + 1)"

End Sub

The code should update the system values table with the current value but it's giving me a parameter value?

Thanks in advance

Ralph

 

[JerryKlmns]

Is this myt!last_num a valid field name in your table?
Is this current_val a valid field name in your table?

UPDATE [i]TableNameHere[/i] SET  [i]FieldNameHere[/i]= [i]NewValue[/i]"

If NewValue is to increment the data in the same field by 1 then

UPDATE [i]TableNameHere[/i] SET  [i]FieldNameHere[/i]= [i]FieldNameHere[/i] +1;

 

[ralphralph07]

Hi

Thanks for the quick response

All sorted

Ralph