On a form I have a listbox. The values in the listbox come from a table named tblBayQuantities. In that table is a numeric field named "Qty"
On the form itself I want a field named txtTotalQty to sum the qty values in tblBayQuantities.
But it doesn't update the total qty when the form I'm using to enter data into the listbox is closed.
What am I doing wrong?