check box on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

[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
 
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

fredg said:
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
Click to expand...

[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
Click to expand...
 
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

fredg said:
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
Click to expand...

[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
Click to expand...
Click to expand...

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.
 
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


fredg said:
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

fredg said:
On Mon, 27 Feb 2006 14:06:03 -0800, Chey wrote:

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

[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
Click to expand...
Click to expand...

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.
Click to expand...
 
Back
Top