Events of databound checkbox

[julius.fuchs]

Hi,

i have created a form with a checkbox that is checked if the current
record is found in another table. This works perfectly with a
selection query. Now I want to append the record to the second table
if the user checks the checkbox and delete it if he unchecks it.
However the onClick event doesn't seem to get fired, does it?
How can I do that?

Thanks in advance

 

[Klatuu]

Use the After Update event

 

[Pat Hartman]

The click event probably doesn't fire for a calculated control since you
can't update it. You'll need to find another method such as putting a
button on the main form or in the footer of the subform.