I need some help with this case:
I have a report (PR_Detail) where the products that are in queue are, the records in this report have a Status field, Quantity field and a Description field. Then I have an other form (PO) that has a subform (PO_Detail, with Quantity and Description fields too) where the users choose the products that they want to purchase, they can only choose the products that are in the PR_Detail report.
I would like that On Success, if the Quantity of a product ordered in the PO form is equal to the total amount of the same product in the PR_Detail report, The status of all records of the same product in this report change to "Purchased".