[AccessD] Trapping a Check Box

[Paul Hartland]

Can't think of the exact event but is there something called oncurrent
record, could you put the code in there to disable or enable the checkboxes
?

Paul

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

> It may be moot.  Just talking to the client and for other reasons has
> decided that this form is no longer necessary - everything's available on
> another for.
>
> Still, I wouldn't mind knowing if there is an easy way.
>
> r
>
> On Mon, Oct 30, 2023 at 10:58 AM Paul Hartland via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > 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
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>