Update table with SQL error 1

[Eprice]

Hi,
Access XP form and table. I am trying to write this update code and get an error. I am not good with writing sql just going off what I found on google. InUse is a Yes/No field and LSN is the serial number they selected in a combo box.

CurrentDb().Execute "UPDATE [tblHardware] SET AutoNo = '" & strAutoNo & "', InUse = True, Where SerialNo = LSN"

Thanks, Lisa

 

[PWise]

How About

CurrentDb().Execute "UPDATE [tblHardware] SET AutoNo = '" & strAutoNo & "', InUse = True, Where SerialNo = 'LSN'"

 

[dhookom]

You didn't tell us the error or what the data type of AutoNo is. This might work. pwise had an extra , after the True.

CurrentDb().Execute "UPDATE [tblHardware] SET AutoNo = '" & strAutoNo & "', InUse = True Where SerialNo = 'LSN'"

Duane
Hook'D on Access
MS Access MVP

 

[Eprice]

Thanks dhookom, that worked for me.
Lisa