Error

[Gr3g0ry]

i have a query that is driving me crazy.

Table Name is USERS and the structure of my table is this:

UserId - AutoNumber
FirstName - text
LastName - text
UserName - text
Password - text
Level - Text
Active - Yes/No

im trying to update with this query:

DoCmd.RunSQL "UPDATE USERS SET FirstName = '" & Me.Fname.Value & "', LastName = '" & Me.Lname.Value & "', UserName = '" & Me.uname.Value & "', Password = '" & Me.pass.Value & "', Level = '" & Me.cboType.Value & "', Active = " & Me.Active.Value & " WHERE UserID = " & Me.cboUser.Value & ";"

and getting errors. ive been trying for the last hour. please render some assistance.

 

[Galaxiom]

What errors specifically?

Rather than directly running the command, assign it to a variable during concatenation and view the contents in the Immediate Window to see what is actually being sent to RunSQL.

 

[Gr3g0ry]

here is my form and table. all im trying to do is grab all my info from the form and write it to the database. im wondering if the value in my WHERE clause affects my query being that it is an autonumber.

 

[Gr3g0ry]

What errors specifically?

Rather than directly running the command, assign it to a variable during concatenation and view the contents in the Immediate Window to see what is actually being sent to RunSQL.

when it crashes and gives me the option to debug, when i mouseover the statements below my UPDATE, i see where all the components have a valuee

 

[Gr3g0ry]

wow thanks man. so the same with double barrelled last names or hyphenated names. good looking out man. thanks