[AccessD] Trapping a Check Box
Rocky Smolin
rockysmolin2 at gmail.com
Mon Oct 30 15:11:57 CDT 2023
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
>
More information about the AccessD
mailing list