SteveL13
asked on
Option group problem
I have an option group on a form. There are 3 checkboxes the user can select from. When the user clicks on one of them another field, named "TotalPopulated" is populated with the numeric value of a separate field named "Total".
But if the user has already selected on of the options, and then changes the value of the field named "Total" then I want the value that was originally populated into "TotalPopulated" to be changed to the new value in "Total".
Sort of as if the user selected the option again.
Can this be done?
I tried in the afterupdate event of the "Total" field:
me.Frame1.requery
but that doesn't work.
But if the user has already selected on of the options, and then changes the value of the field named "Total" then I want the value that was originally populated into "TotalPopulated" to be changed to the new value in "Total".
Sort of as if the user selected the option again.
Can this be done?
I tried in the afterupdate event of the "Total" field:
me.Frame1.requery
but that doesn't work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER