>>In the property sheet for the checkbox enter "=DELETED()" wihtout the quotes for the controlsource property.
>
>Could not get this code accepted into the controlsource. Tried all sorts of variations. Always got an error message "The data source for this object must be a variable reference" immediately after trying to enter this code in the countrolsource.
>
>Eventually found that entering the following code in brackets was finally accepted by the controlsource of the checkbox.
>
>(deleted())
>
>This now works, and the ticks are in sync with the deleted records.
>
>However, there is a new problem, because now every time you check or uncheck the checkbox, you get a warning bell and a status bar message "The record is read only". The deleting and undeleting works perfectly. But the bell and message are the problem now.
>
>regards
I would keep the controlsource empty (unbound field) and handle it in refresh/click as you're doing already.
If it's not broken, fix it until it is.
My Blog