Seems, you're trying to update row which is not in edit mode.
There might be 2 reasons:
1) a recordset is open in static mode
2) you didn't added
.Edit
instruction.
Here is suggested code:
Case 1 - multiple records
rs.Open "Select * from Inventory where InventoryID = " & Val(.ListSubItems(6).Text)
With rs
Do While Not .EOF
.Edit
.Update
.MoveNext
Loop
End With
Case 2 - single record
rs.Open "Select * from Inventory where InventoryID = " & Val(.ListSubItems(6).Text)
With rs
.Edit
.Update
End With
For further details, please check the documentation:
Open Method (ADO Recordset) | Microsoft Docs[
^]
Recordset.Update Method (DAO)[
^] - with working example