I am creating a database where multiple machine operators record each run. The record includes the initial order quantity, the amount of parts produced (good and bad), the number of parts previously ran, and the remaining quantity of parts for the order to be complete. The machine operator makes an entry for every bed they have completed. I would like a box on the form that details how many parts have been previously ran by searching the table and returning only the sum off all good parts ran where the Work Order Number and File Number match what has been currently been entered on the form. It needs to be dynamic so that the number is updated each time a new bed has been completed, and produces a pop up stating that the order is complete. Any help would be greatly appreciated.