Update strsql does not work...

[kxcntry99]

Have you tried putting the SQL string into a message box after the values are filled in? If not, try that and post the results of exactly what SQL string the app is sending to Access. For example:

If Check = vbYes Then
Yes = True
strUpdateEmail = "UPDATE [User] SET Email = '" & Me.txtFillEmail.Value & "' WHERE WindowsUser ='" & Me.txtFillWindowsUser.Value & "';"
[B]MsgBox strUpdateEmail[/B]
DoCmd.RunSQL strUpdateEmail