Updating records in ms access Adult sex site dating script
After having found the record you can read or change the record's field values as explained under Edit a record in a DAO Recordset.
Use the Move methods to move from record to record without applying a condition.
Now whenever the record changes in the form, the subform should refresh itself.
To be honest, your query doesn't make much sense, as it says: "update the Quantity to 5 where the Quantity is 5". Refine your query in Access, and once it works, paste it back to the VBA code.
Execute " UPDATE damaged_card " & _ " SET Quantity='" & Me.txtquantity & "'" & _ " WHERE Quantity=" & Me.txtquantity. If it still fails, check the values in runtime and try running the SQL manually and see if it works that way.
However, Access kept giving me the syntax error message shown below.
Syntax error (missing operator) in query expression 'count(distinct Reports To)'.
If you are unable to find common fields between your form and subform, you can always place code on the "On Current" event of the form to refresh the subform. Scroll down until you find the property called "On Current".
Then click on the button with the three dots to the right of this property.