I have a form "Registrations" based on a query called "Registrations Extended". On it are a series of check box controls for various events the registrant can participate in. The query calculates the total number of events checked. The number is displayed in a text box control and updates when ever an event is checked or uncheched. Also there are a handful of text box controls for the user to enter a quantity for the various materials available for purchase. There is also a subform, "Fees subform" based on another query that calculates the fees based on events and materials ordered. It also shows the amount paid and the balance due.
I want the values displayed in the "Fees subform" to update as events are selected/deselected and the material quantities are changed. It updates if I refresh by hitting the F5 key, however, the ultimate users of the database will find that inconvenient and most likely confusing. So I need to automate this.
I have tried, unsuccessfully, using requery in macros and VBA for various events including After update, On click, etc.
Any suggestions?