How do I get the IIF Function to automatically update a Check Box in a form?

[Terry]

Hello,
I am designing a form from scratch and need to know how to get a Check
Box(PASS)to automatically update when the data in a Text Box (MARK),
in the same
form, is >=24.
Using the Event dialogue box for the Check Box, AfterUpdate, I have
tried:
IIf([MARK]>=24,True,False)
Also:
IIf([MARK]>=24,1,0)
Also:
IIf([MARK]>=24,"Yes","No")

Although I get no error messages, nothing seems to work.
Any suggestions?

[Jim Allensworth]

On 22 Nov 2003 09:28:00 -0800, tc*****@merseymail.com (Terry) wrote:

Hello,
I am designing a form from scratch and need to know how to get a Check
Box(PASS)to automatically update when the data in a Text Box (MARK),
in the same
form, is >=24.
Using the Event dialogue box for the Check Box, AfterUpdate, I have
tried:
IIf([MARK]>=24,True,False)
Also:
IIf([MARK]>=24,1,0)
Also:
IIf([MARK]>=24,"Yes","No")

Although I get no error messages, nothing seems to work.
Any suggestions?

Use the After Update event of the Text Box since that is what is being
updated. Try this...
Me.PASS = Me.MARK >= 24

- Jim

[Terry]

Ji****@NOTdatacentricsolutions.com (Jim Allensworth) wrote in message news:<3f**************@netnews.comcast.net>...

On 22 Nov 2003 09:28:00 -0800, tc*****@merseymail.com (Terry) wrote:

Hello,
I am designing a form from scratch and need to know how to get a Check
Box(PASS)to automatically update when the data in a Text Box (MARK),
in the same
form, is >=24.
Using the Event dialogue box for the Check Box, AfterUpdate, I have
tried:
IIf([MARK]>=24,True,False)
Also:
IIf([MARK]>=24,1,0)
Also:
IIf([MARK]>=24,"Yes","No")

Although I get no error messages, nothing seems to work.
Any suggestions?

Use the After Update event of the Text Box since that is what is being
updated. Try this...
Me.PASS = Me.MARK >= 24

- Jim

Tried thet Jim...got an error message saying "Can'tfind Macro .Me

Terry

[Jim Allensworth]

On 22 Nov 2003 14:27:59 -0800, tc*****@merseymail.com (Terry) wrote:

Ji****@NOTdatacentricsolutions.com (Jim Allensworth) wrote in message news:<3f**************@netnews.comcast.net>...

On 22 Nov 2003 09:28:00 -0800, tc*****@merseymail.com (Terry) wrote:

>Hello,
>I am designing a form from scratch and need to know how to get a Check
>Box(PASS)to automatically update when the data in a Text Box (MARK),
>in the same
>form, is >=24.
>Using the Event dialogue box for the Check Box, AfterUpdate, I have
>tried:
>IIf([MARK]>=24,True,False)
>Also:
>IIf([MARK]>=24,1,0)
>Also:
>IIf([MARK]>=24,"Yes","No")
>
>Although I get no error messages, nothing seems to work.
>Any suggestions?

Use the After Update event of the Text Box since that is what is being
updated. Try this...
Me.PASS = Me.MARK >= 24

- Jim

Tried thet Jim...got an error message saying "Can'tfind Macro .Me

Terry

Terry it sounds like you copied that into the properties window
itself. This is VBA code, it belongs in the forms module.

Do this...

Open the textbox's properties go the the After Update event. Delete
what you had in there.

Press the elipsis button [...] to the right of the event. (If the
Builder window opens choose Code Builder)

This will open the form's module to the textboxes After Update event.
Paste the expression into it. It should look something like this

Private Sub txtMyTextBox_AfterUpdate()
Me.PASS = Me.MARK >= 24
End Sub

Note your textbox's name will be there is place of "txtMyTextBox".

If that doesn't work for you post back with your code.

- Jim

[Terry]

Ji****@NOTdatacentricsolutions.com (Jim Allensworth) wrote in message news:<3f***************@netnews.comcast.net>...

On 22 Nov 2003 14:27:59 -0800, tc*****@merseymail.com (Terry) wrote:

Ji****@NOTdatacentricsolutions.com (Jim Allensworth) wrote in message news:<3f**************@netnews.comcast.net>...

On 22 Nov 2003 09:28:00 -0800, tc*****@merseymail.com (Terry) wrote:

>Hello,
>I am designing a form from scratch and need to know how to get a Check
>Box(PASS)to automatically update when the data in a Text Box (MARK),
>in the same
>form, is >=24.
>Using the Event dialogue box for the Check Box, AfterUpdate, I have
>tried:
>IIf([MARK]>=24,True,False)
>Also:
>IIf([MARK]>=24,1,0)
>Also:
>IIf([MARK]>=24,"Yes","No")
>
>Although I get no error messages, nothing seems to work.
>Any suggestions?

Use the After Update event of the Text Box since that is what is being
updated. Try this...
Me.PASS = Me.MARK >= 24

- Jim

Tried thet Jim...got an error message saying "Can'tfind Macro .Me

Terry

Terry it sounds like you copied that into the properties window
itself. This is VBA code, it belongs in the forms module.

Do this...

Open the textbox's properties go the the After Update event. Delete
what you had in there.

Press the elipsis button [...] to the right of the event. (If the
Builder window opens choose Code Builder)

This will open the form's module to the textboxes After Update event.
Paste the expression into it. It should look something like this

Private Sub txtMyTextBox_AfterUpdate()
Me.PASS = Me.MARK >= 24
End Sub

Note your textbox's name will be there is place of "txtMyTextBox".

If that doesn't work for you post back with your code.

- Jim

Jim, Put the following code in as you said:

Private Sub Mark_AfterUpdate()
Me.Pass = Me.Mark >= 24
End Sub

Didn't get anything when I tried it out on the form, but when I closed
the form I got a runtime error '2113' "The value you have entered
isn't valid for this field" ....I clicked the Debug button. This
brought me back to the VBA code and the line:

Me.Pass = Me.Mark >= 24

was highlighted in yellow, with a yellow arrow to the left.

This has thrown me altogether as I couldn't find out how to actually
debug.

In the database I'm creating, I have made a relationship between the
"Student Details" table and the "Exam details" table so that I have a
single form with some fields from each table.

The Student Details Section Is at the top of the form, i.e ID, Name &
Location, and the Exam details are sort of embedded into this form in
the bottom half.

This means that a subform also exists for Exam details. I thought this
might have some baring on the result and placed the code in both the
form and the subform but the result is exactly the same.