Continuous Form - Update Textbox

[GoinDeep]

Continuous Form Help, text box update.

I have a Continuous Form based on a table of multiple records. With each record I have a check box "chkRplcd" which is checked if a piece of equipment is replaced. I also have a bound textbox "txtEquipDate" which specifies the date of that particular piece of equipment.

I have VB code If the check box is checked it replaces the equipment date with the current date.

My problem is: If the user reviews the form and decides they checked the wrong piece of equipment for replacement they want to uncheck the "chkRplcd" box and have the equipment date revert back to its original value.

I've done this easily with a single form but cannot get it to work with the continous form.

Thanks for any help!

 

[Kraj]

A possible solution: instead of changing the date to the current date when they check the box, run your code when they close the form to change all the date boxes that are checked.

If you want them to be able to open the form up later and revert the date, that is a different scenario an my idea won't work.