order Amend tick box Refresh

[kabir_hussein]

Hi on my database i have a order amendment form where if any changes are made to an order, the order amendment check box ticks it self.

This works fine, and is very useful when printing a order change report as the query just looks for all "yes" for order amendment


but i have been told that a order may be changed more than once, so i was thinking is there anyway where i can make changes to a form then when i close the form and the reopen it the tick are set back to "NO" ready for new changes. this way the report function will work again, by only looking for "Yes" changes.

Thank you

below is a picture how the form looks

 

[Jerry Stoner]

On the open event of the form add code like Me.MyCheckBoxName.Value = 0.
This however gives you no history of changes, just unchecks the box.

 

[kabir_hussein]

cheers mate works fine

thank you