Update Statement VBA Access

hazeleyre23

Registered User.
Local time
Today, 08:54
Joined
Apr 6, 2016
Messages
18
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?!

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

Thank you
 
your other post is correct, since new_id is numeric you dont need to enclosed it in quote mark.
 
THANK YOU SO MUCH!

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

Users who are viewing this thread

Back
Top Bottom