form dirty trigger

[spinkung]

hi

my form has some unbound radio buttons (Yes/No options) which when changed update the value in a hidden bound textbox (values Y and N, the db was set up this way unfortunately).

i want to create a rollback table so that changes can be undone. so, on the forms dirty event i insert the current filtered recordsource into my rollback table so it can be 'reset' to it's original values if the operator decides to cancel their changes.

this works fine if i change a text box. it doesn't fire the dirty event though if i change a radio button even though the bound field is being changed in my code.

anyone know how to get it to trigger?

Thanks,
spin

 

[JamesMcS]

hi

my form has some unbound radio buttons (Yes/No options) which when changed update the value in a hidden bound textbox (values Y and N, the db was set up this way unfortunately).

i want to create a rollback table so that changes can be undone. so, on the forms dirty event i insert the current filtered recordsource into my rollback table so it can be 'reset' to it's original values if the operator decides to cancel their changes.

this works fine if i change a text box. it doesn't fire the dirty event though if i change a radio button even though the bound field is being changed in my code.

anyone know how to get it to trigger?

Thanks,
spin

Could you just put the code in the option group's on click?