Checkbox in a datasheet - cheating with a UNIQUES recordsource query?
Posted on 2006-06-29
I have a datasheet on a form that contains a checkbox.
For one condition, the datasheet's recordsource is based on a UNIQUES query, thus the recordset is not updatable. Therefore, the checkbox is not functional. The UNIQUES query is required as the the condition produces duplicate results. There are also two JOINS in the query and I have selected the Dynaset "Inconsistent Updates" option in the query and in the datasheet.
Can anyone suggest a method (or a cheat) to allow the checkbox to be "checked" even in this condition? I do note that the double-click event is functional, single-click is not.
Any creative ideas?