SQL command using textbox from form

[Delindan]

I'm having trouble getting the syntax correct on a sql statement that uses information from two text boxes on my form. Here is what I'm trying:

DoCmd.RunSQL "UPDATE [FS Specialists], SET [FS Specialists]! = '" & Trim(Me!txtemail) & "' WHERE [FS Specialists]![FS Specialist] = '" & Trim(Me!txtfsspecialist) & "';"

Anything obvious?

Thanks!

 

[PHV]

What about this ?

DoCmd.RunSQL "UPDATE [FS Specialists] SET Email='" & Trim(Me!txtemail) & "' WHERE [FS Specialist]='" & Trim(Me!txtfsspecialist) & "'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Delindan]

It worked great. I'm guessing it was the extra comma...thanks so much!!