The controls you are interested in have an .OldValue property that will keep the previous value until the update is complete. You can loop through the controls and reset them to the old value.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
I was checking on the help file, and even this OldValue property works only with bound controls, but what if my controls are unbound, they are not linked to a table directly, but later i will link the controls to the table
thanks for replying jebry
Sorry about the misdirect there. The only other thing I can think of is to set up an array at the form level and load it with the control names and value in the Current event. You can then use the array to reset the values if needed.
hth
Jeff Bridgham
Purdue University
Graduate School
Data Analyst
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.