I am making a take away database, so when different quantities, or products are chosen it will affect the total price.
The total price is a query with the function SumOf. However, when updating the form i must go to the next record and then back again, or exit the form and re - opening before seeing the update. I am told that a Requery function will be able to solve this problem and update it.
But after playing around with the function i cannot get it to work?
Also, keep in mind that just because the data is changed on the form, the data not be committed to the table the query is looking at. In order to update as soon as the user makes a change to the record you will need to save the record. You can use: