Could some please help with a syntax error in my VBA Sql code as follows:-
All above fields are text fields
Code:
strSQL = "UPDATE [patient] " _
& "SET [Current_Med] = '" & MyMed & "', _
& [SType1_Desc] = '" & Me.SType_1 & "', _
& [SType2_Desc] = '" & Me.SType2 & "', _
& [SType3_Desc] = '" & Me.Stype3 "'" _
& "WHERE ([UID] = '" & Me.Web_UID & "')"
All above fields are text fields