I have a form that I collect information of from callers. On that form are several controls that are used in calculating the total delivery costs for a the delivery the caller is requesting.
At the bottom of the on the existing record is a TotalCharges field. I have set the double click event of this control (TotalCharges) to create a total charge based on several fields. Everything works fine. I would just like to be able to create a module or function that can be called from any textbox's afterupdate event to calculate the total charges and update the TotalCharges textbox.
Is it possible to use the private sub code in a module for public function and be able to call it form any field on the form to update the record (total the delivery charges)?
It is possible to set the focus to TotalCharges and call the double click event to get the update but that means I have to use the mouse to move back to the next field i want to add information to.
I hope this isn't to vague.
Thanks, Randy