Tick Box problem

[Tony Williams]

I have a series of tickbox controls on a form. When the user clicks on them
a form is opened, I used the onclick event to do this. However if the user
clicks the tickbox in error the form will open and then if they unlick it if
they have clicked in error the form opens again. Is there anyway that I can
stop the form opening on unclick?

--
Tony Williams

[tina]

>-----Original Message-----
>I have a series of tickbox controls on a form. When the

user clicks on them

>a form is opened, I used the onclick event to do this.

However if the user

>clicks the tickbox in error the form will open and then

if they unlick it if

>they have clicked in error the form opens again. Is there

anyway that I can

>stop the form opening on unclick?
>
>--
>Tony Williams
>
>
>.
>set a procedure to run from the tickbox's On Click event,

as
Private Sub TickBox_Click()
If Me!TickBox Then
DoCmd.OpenForm "FormName"
End If
End Sub

i didn't test above, so...if On Click doesn't work, try
using the After Update event.

or you could nip the problem in the bud by automatically
unticking the box when the form opens, as
Private Sub TickBox_Click()
If Me!TickBox Then
DoCmd.OpenForm "FormName"
Me!TickBox = False
End If
End Sub
again, try the After Update event if On Click doesn't work.

[Tony Williams]

Thanks Tina but the form still opens on the unclick of the tick box. I want
to stop the form opening if the user unchecks the tickbox
Thanks
Tony
"tina" <californiadreamin7@arrowfm.com> wrote in message
news:06c501c3528e$883f0150$a601280a@phx.gbl...

>

> >-----Original Message-----
> >I have a series of tickbox controls on a form. When the

> user clicks on them

> >a form is opened, I used the onclick event to do this.

> However if the user

> >clicks the tickbox in error the form will open and then

> if they unlick it if

> >they have clicked in error the form opens again. Is there

> anyway that I can

> >stop the form opening on unclick?
> >
> >--
> >Tony Williams
> >
> >
> >.
> >set a procedure to run from the tickbox's On Click event,

> as
> Private Sub TickBox_Click()
> If Me!TickBox Then
> DoCmd.OpenForm "FormName"
> End If
> End Sub
>
> i didn't test above, so...if On Click doesn't work, try
> using the After Update event.
>
> or you could nip the problem in the bud by automatically
> unticking the box when the form opens, as
> Private Sub TickBox_Click()
> If Me!TickBox Then
> DoCmd.OpenForm "FormName"
> Me!TickBox = False
> End If
> End Sub
> again, try the After Update event if On Click doesn't work.

[tina]

okay, tony, i was awake enough to test the code this
morning. if you place the first procedure on the tickbox's
On Click event, it will run correctly and give you the
result you want. if you remove the procedure from the On
Click event, and place either the first or second
procedure on the After Update event, the one you use will
run as i described below.
really! :-)

by the way, a checkbox has a boolean value, so in an
If...Then statement, both of the following expressions
evaluate the same:
If Me!Tickbox Then
If Me!Tickbox = True Then

>-----Original Message-----
>Thanks Tina but the form still opens on the unclick of

the tick box. I want

>to stop the form opening if the user unchecks the tickbox
>Thanks
>Tony
>"tina" <californiadreamin7@arrowfm.com> wrote in message
>news:06c501c3528e$883f0150$a601280a@phx.gbl...

>>

>> >.
>> >set a procedure to run from the tickbox's On Click

event,

>> as
>> Private Sub TickBox_Click()
>> If Me!TickBox Then
>> DoCmd.OpenForm "FormName"
>> End If
>> End Sub
>>
>> i didn't test above, so...if On Click doesn't work, try
>> using the After Update event.
>>
>> or you could nip the problem in the bud by automatically
>> unticking the box when the form opens, as
>> Private Sub TickBox_Click()
>> If Me!TickBox Then
>> DoCmd.OpenForm "FormName"
>> Me!TickBox = False
>> End If
>> End Sub
>> again, try the After Update event if On Click doesn't

work.

>
>
>.
>

[Tony Williams]

Thanks Tina worked just fine
Tony
"tina" <californiadreamin7@arrowfm.com> wrote in message
news:003d01c352d6$4ba50210$a601280a@phx.gbl...

> okay, tony, i was awake enough to test the code this
> morning. if you place the first procedure on the tickbox's
> On Click event, it will run correctly and give you the
> result you want. if you remove the procedure from the On
> Click event, and place either the first or second
> procedure on the After Update event, the one you use will
> run as i described below.
> really! :-)
>
> by the way, a checkbox has a boolean value, so in an
> If...Then statement, both of the following expressions
> evaluate the same:
> If Me!Tickbox Then
> If Me!Tickbox = True Then
>
>

> >-----Original Message-----
> >Thanks Tina but the form still opens on the unclick of

> the tick box. I want

> >to stop the form opening if the user unchecks the tickbox
> >Thanks
> >Tony
> >"tina" <californiadreamin7@arrowfm.com> wrote in message
> >news:06c501c3528e$883f0150$a601280a@phx.gbl...

> >>
> >> >.
> >> >set a procedure to run from the tickbox's On Click

> event,

> >> as
> >> Private Sub TickBox_Click()
> >> If Me!TickBox Then
> >> DoCmd.OpenForm "FormName"
> >> End If
> >> End Sub
> >>
> >> i didn't test above, so...if On Click doesn't work, try
> >> using the After Update event.
> >>
> >> or you could nip the problem in the bud by automatically
> >> unticking the box when the form opens, as
> >> Private Sub TickBox_Click()
> >> If Me!TickBox Then
> >> DoCmd.OpenForm "FormName"
> >> Me!TickBox = False
> >> End If
> >> End Sub
> >> again, try the After Update event if On Click doesn't

> work.

> >
> >
> >.
> >