check box issue in a continuous form

[SpiritedAway]

Hi All,

I've got a check box on a continuous form, yet when I click on it in in a record that has the focus it checks all the other check boxes in my form.

Trouble is I lock it on the AfterUpdate event, which means when i click on another records they're all locked.

Is there a way of simply checking the box in the record that has focus without having all the others checked too???

 

[r.harrison]

Hi,

Is the checkbox bound to a table, or is it unbound?

 

[vbaInet]

Yep, like r.harrison suspects, the checkbox is unbound.

You need to set the Control Source of the checkbox.

 

[SpiritedAway]

ah!!!! Never thought of that - they are unbound - will make them bound to the table - -- thanks for your help!!!!!