Update Statement VBA Access (1 Viewer)

[hazeleyre23]

Do I just add the dbSeeChanges to the end of the statement.

Do I need to do anything before as currently is this is my full code, from reading other forums I think I might be missing parts?!

Private Sub cmdUpdateToDate_Click()
   
        CurrentDb.Execute "UPDATE dbo_Agent_Data SET ToDate = #" & Me!txtUpdateToDate & "# WHERE [id_NEW] = '" & Me!txtUpdateID & "'"
           
End Sub

Thank you

 

[arnelgp]

your other post is correct, since new_id is numeric you dont need to enclosed it in quote mark.

 

[hazeleyre23]

THANK YOU SO MUCH!

This has solved it.....thank you again