unbound checkbox in datasheet view?

[Guest]

I have a form with a single unbound checkbox with code behind it's
AfterUpdate event that updates the value of a bound field; this works as
expected in form view but not datasheet view.

The checkbox is replicated for each datasheet record as expected, but when a
single records checkbox is clicked all of the records are simultaneously
checked/unchecked (although the code is still correctly applied to only the
current record). Is there a way to control the displayed checkbox
independently for each record without making it a bound control?

Your suggestions are appreciated.

 

[fredg]

I have a form with a single unbound checkbox with code behind it's
AfterUpdate event that updates the value of a bound field; this works as
expected in form view but not datasheet view.

The checkbox is replicated for each datasheet record as expected, but when a
single records checkbox is clicked all of the records are simultaneously
checked/unchecked (although the code is still correctly applied to only the
current record). Is there a way to control the displayed checkbox
independently for each record without making it a bound control?

Your suggestions are appreciated.

That's not how you do it.
You need to first add a new check box field to your underlying table.
Then add it to the form so that it is BOUND to that field in the
table. No Update code needed.

 

[Guest]

I didn't think I could modify a system table.

 

[Rick Brandt]

I didn't think I could modify a system table.

Who said anything about a "system table"?