[AccessD] Trapping a Check Box

[Paul Hartland]

Not played with access for a while, hopinv to have a play this week for
someone else on this list unless they have got a solution, anyway is there
a click event for the checkbox, if there is, have you tried putting the
code in there instead.

Paul

On Mon, 30 Oct 2023, 17:42 Rocky Smolin, <rockysmolin2 at gmail.com> wrote:

> Dear List(s):
>
> I have a form the record source of which is a non-updateable query.  On the
> continuous form are two check boxes which need to be updated. No problem.
> In the Mouse Down event, I take care of everything that needs taking care
> of when the state of the check box changes.
>
> However, there are some records where those check boxes need to be kept at
> false and I know what the condition is to test to know whether a change
> from false to true is illegal (if they were text boxes, it would be simple
> - use conditional formatting to make those boxes disabled. But that would
> be too easy. No conditional formatting on a check box).
>
> I've tried a few things in my MouseDown event to keep that check box false
> but have failed to find the solution. :o(
>
> Does anyone know how to do this?
>
> MMTIA
>
> Rocky
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>