ralphralph07
MIS
Hi
I have a database that i have inherited and i'm getting the an error on the following line of code:
The code should update the system values table with the current value but it's giving me a parameter value?
Thanks in advance
Ralph
I have a database that i have inherited and i'm getting the an error on the following line of code:
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