Update Query Problem

[kappa]

I am trying to update a field in a table with the word "No" via an update query.
I am not sure of the correct procedure with a string..
The code below, writes a "0" when run..

strSQLstatement = "UPDATE [Tblstock_item] SET [Tblstock_item].[Available] = No " & " WHERE [Tblstock_item].[Stock_Item_No] = " & strStockItem

Thanks in advance

 

[kappa]

Problem Solved..

strSQLstatement = "UPDATE [Tblstock_item] SET [Tblstock_item].[Available] = 'No'
" & "WHERE [Tblstock_item].[Stock_Item_No] = " & strStockItem