This is to request help with VBA coding not working as expected. I am using Access 2007 under MS Win 10 x64. I have a tblAssets (Inventory) with the following structure: AssetID, AutoNumber; PerformanceType, Number; Title, Text; Description, Text; Writer1LastName, Text; Writer1FirstName, Text; Writer2LastName, Text; Writer2FirstName, Text; Writer3LastName, Text; DateofIntro, Date/Time; RightsID, Number; PrimaryLoc, Number; SecondaryLoc, Number; TertiaryLoc, Number; OnHand, Yes/No. Initially each record has a check mark (Yes) in the OnHand field. Then, I use a multi-part form to "issue out" an Asset. The primary/main form has multiple "buttons" to perform necessary functions relating a single record selected by inputs to the form(s). All of the form functions seem to perform satisfactorily (without error); however, one button (Update On Hand Status) does not make the desired change. The Event Procedure coding for that button is:
Private Sub UpdateOH_Click()
Dim strSQL As String
' Set OnHand status to "No" since Asset is being issued out.
strSQL = "UPDATE tblAssets SET tblAssets.OnHand = " & False
End Sub
If further information is needed, I will quickly share it, but I would really appreciate help with where I am going wrong here. Thanks.