Hello Friends!
Happy new year to you all!
My form has a lot of fields which collect information that is used to calculate insurance premium. I designed the form for user to enter data and ideally when all data is entered, user clicks on a button that runs a macro to calculate the rate.
Everything seems to be fine except when user has the cursor on a field (e.g a date field) and then clicks on the "Calculate" button - the new entered value is not being registered - my codes are still picking up the old value.
Sorry if this is not clear. Let's say there's a date field where user initially entered 01/2004 and user goes back and updates the field to 01/2006. When the "Calculate"button is clicked, the codes are using 01/2004 instead of 01/2006. The problem only occurs when user leaves the cursor on the date field. There would be no problem if user presses Tab or move the cursor to another field (which would register the new value).
Any help would be greatly appreciated.
Thanks!
Allan
Happy new year to you all!
My form has a lot of fields which collect information that is used to calculate insurance premium. I designed the form for user to enter data and ideally when all data is entered, user clicks on a button that runs a macro to calculate the rate.
Everything seems to be fine except when user has the cursor on a field (e.g a date field) and then clicks on the "Calculate" button - the new entered value is not being registered - my codes are still picking up the old value.
Sorry if this is not clear. Let's say there's a date field where user initially entered 01/2004 and user goes back and updates the field to 01/2006. When the "Calculate"button is clicked, the codes are using 01/2004 instead of 01/2006. The problem only occurs when user leaves the cursor on the date field. There would be no problem if user presses Tab or move the cursor to another field (which would register the new value).
Any help would be greatly appreciated.
Thanks!
Allan