value driven if then statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AndyM - 22 Jun 2006 19:18 GMT

Ok, I have the below series of statements, but when I place the word Inbox in
the field "stresseng", it seems to not acknowledge it. The code is below, but
what I'm doing is I'm checking if stresseng has a value, and if it does, I
need to check if that value is inbox. If it is, then I need to keep the
"stresscheck" checkbox checked. If anything else is in the stresseng field, I
want to uncheck the checkbox. Finally, if there's nothing in the stresseng
field, I want to keep the stresscheck checked. Let me know if you notice any
thing off. BTW, the stresseng field is from a combo box.

If Not IsNull(Me.stresseng.Value) Then
If Me.stresseng.Value = "Inbox" Then
Me.StressCheck = True

Else
Me.StressCheck = False

End If

Else
Me.StressCheck = True
End If

Reply to this Message

Lynn Trapp - 22 Jun 2006 19:27 GMT

Have you tried stepping through your code to see what is happening?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

> Ok, I have the below series of statements, but when I place the word Inbox
> in
[quoted text clipped - 21 lines]
> Me.StressCheck = True
> End If

Reply to this Message

AndyM - 22 Jun 2006 20:18 GMT

yes,
I have used a message box to confirm that it gets through everything, but
goes to the else part of the if then statement which addresses the inbox
entry. I have placed the location where I put this messagebox below.
Thanks

> Have you tried stepping through your code to see what is happening?
>
[quoted text clipped - 23 lines]
> > Me.StressCheck = True
> > End If

Reply to this Message

Klatuu - 22 Jun 2006 20:43 GMT

Try this variation:
Me.StressCheck = IsNull(Me.stresseng) Or Me.stresseng = "InBox"

> Ok, I have the below series of statements, but when I place the word Inbox in
> the field "stresseng", it seems to not acknowledge it. The code is below, but
[quoted text clipped - 17 lines]
> Me.StressCheck = True
> End If

Reply to this Message

AndyM - 22 Jun 2006 21:36 GMT

Thanks for the suggestion.
Actually, I just placed a messagebox in the code and found that for inbox,
me.stresseng came up as being "15". This came from the Primary Key from the
table I built the combo box from. To fix it, I used my original code and
moved the id column to the second position. It seems to work fine now.

> Try this variation:
> Me.StressCheck = IsNull(Me.stresseng) Or Me.stresseng = "InBox"
[quoted text clipped - 20 lines]
> > Me.StressCheck = True
> > End If

Reply to this Message