check box on form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chey - 27 Feb 2006 22:06 GMT

I have a check box on my form. Under the main form properties I have a code
IIF([Page1]>0, then
Grant turned in True.

I have the code under current and it works.
The only way it works is if I close and come back to it.
I need to know which one to place the code under to make it work right away.
When I type a number in page one, then grant turned in should be checked.
Thanks

Reply to this Message

fredg - 27 Feb 2006 22:38 GMT

> I have a check box on my form. Under the main form properties I have a code
> IIF([Page1]>0, then
[quoted text clipped - 5 lines]
> When I type a number in page one, then grant turned in should be checked.
> Thanks

[Page1] is a control on your form?
If the code is now working after you close and reopen the form, then
place the same code in the [Page1] AfterUpdate event.

Actually a simpler code can be used:
[GrantTurnedIn] = Me![Page1] > 0

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Chey - 28 Feb 2006 01:36 GMT

Okay that worked Now I have another one
I have text134 when this say ok then I want text box [ZEZA] to be checked
automatically. Where do I put that? AfterUpdate? But exactly where. I
tried different places and It doesen't work.
Thanks

> > I have a check box on my form. Under the main form properties I have a code
> > IIF([Page1]>0, then
[quoted text clipped - 12 lines]
> Actually a simpler code can be used:
> [GrantTurnedIn] = Me![Page1] > 0

Reply to this Message

fredg - 28 Feb 2006 03:33 GMT

> Okay that worked Now I have another one
> I have text134 when this say ok then I want text box [ZEZA] to be checked
[quoted text clipped - 18 lines]
>> Actually a simpler code can be used:
>> [GrantTurnedIn] = Me![Page1] > 0

Chey,
This question is just about the same as the one you just said "OK it
worked" to.
Sentences like "I tried different places and It doesen't work." does
not give us much help.
What specifically did you try?
Where specifically did you place it?

These newsgroups are to help everyone who may have a problem, not just
the original poster. As your original post seems to have been answered
correctly why not start a new thread, so that someone else, who may
have a similar problem, can learn also. Be specific.

Thanks.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Chey - 28 Feb 2006 17:49 GMT

sorry about that.
I have text134, when a 2 is in there then Zero Enrollement, Zero Attendance=
False. (ZEZA) is a checkbox.
Under text134
for on change I put
[Zero Enrollement, Zero Attendance] = Me![Text136] =0
If there is a 0 then it is True I am not sure on that one so I tired

If [Text136] = 0 Then
[Zero Enrollement, Zero Attendance] = True
Else
[Zero Enrollement, Zero Attendance]= False

> > Okay that worked Now I have another one
> > I have text134 when this say ok then I want text box [ZEZA] to be checked
[quoted text clipped - 33 lines]
>
> Thanks.

Reply to this Message