Hi guys,
I posted yesterday about incorrect syntax again for an update statement, however I've got a new error with a different line of code. I just copy and pasted it from this
and transferred it to this
When I run this code however with Currentdb.Execute(), it returns an error saying " Syntax error (missing operator) in query expression "AircraftID ='. "
Any help is greatly appreciated!
Thanks, Ryan
I posted yesterday about incorrect syntax again for an update statement, however I've got a new error with a different line of code. I just copy and pasted it from this
Code:
"UPDATE tblUserLogins SET Password = '" & Me.txtNewPass1 & "' WHERE LoginID = " & LoginID
and transferred it to this
Code:
"UPDATE tblAircraftDetails SET Registration = '" & Me.txtRegistration & "' WHERE AircraftID = " & ID
When I run this code however with Currentdb.Execute(), it returns an error saying " Syntax error (missing operator) in query expression "AircraftID ='. "
Any help is greatly appreciated!
Thanks, Ryan