Checkbox not working

[terryvanduzee]

Hello

I have a checkbox that I have some code written on the "Afterupdate" event.
I checked the value of the checkbox both checked and unchecked; it comes up as -1 and 0.
In my code, I am checking the value for being true or false, but it does not seem to see it as true or false:

In the table design, I have it designated as "True/False".


Neither true or false seems to run my code, just jumps to the end if.

If Me.Item_Sold = True Then 'this is my checkbox

    Dim name As String
    Dim box As String
    
    Select Case Me.Itemname.Value
        Case Is = "Embrace"
            Me.Itemname.Value = "Embrace Odd Boxspring"
            Me.Item_OddBox.Value = "Semi-Flex"
        Case Is = "Majestic Pearl"
            Me.Itemname.Value = "Majestic Pearl Odd Boxspring"
            Me.Item_OddBox.Value = "Majestic Pearl Odd Boxspring"
        Case Is = "Chiro-Majestic"
            Me.Itemname.Value = "Chiro-Majestic Odd Boxspring"
            Me.Item_OddBox.Value = "Chiro-Majestic Odd Boxspring"
        Case Is = "Camden"
            Me.Itemname.Value = "Camden Odd Boxspring"
            Me.Item_OddBox.Value = "Camden Odd Boxspring"
        Case Is = "Jubilee"
            Me.Itemname.Value = "Jubilee Odd Boxspring"
            Me.Item_OddBox.Value = "Jubilee Odd Boxspring"
        Case Is = "Ameripedic II Plush"
            Me.Itemname.Value = "Ameripedic II Plush Odd Boxspring"
            Me.Item_OddBox.Value = "Ameripedic II Plush Odd Boxspring"
        Case Is = "Ameripedic II Pillow Top"
            Me.Itemname.Value = "Ameripedic II Pillow Top Odd Boxspring"
            Me.Item_OddBox.Value = "Ameripedic II Pillow Top Odd Boxspring"
        Case Is = "Hotel"
            Me.Itemname.Value = "Tan Odd Boxspring"
            Me.Item_OddBox.Value = "Tan Odd Boxspring"
        Case Else
            Me.Itemname.Value = "Snow"
            Me.Item_OddBox.Value = "Snow"
    End Select
End If

Any Ideas
Thank you
Terry

[SoftwareMatters]

Try changing Me.Item_Sold to Me!Item_Sold or why don't you just put If Me!Item_Sold = -1 Then

[Pimped]

-1 is true
0 is false

in vba, you can set a break point by clicking in the left ruler area so that the program stops at that point and you can hover your mouse over the items to see their values.

If (Me.Item_Sold = -1) Then

[terryvanduzee]

Hello

Yes, I set a breakpoint. I tried using 0 and -1. The problem was mine... a typo, I had the name of the object misspelled.

Thank you for your suggestions.

Terry

[RuralGuy]

If you have:
Option Explicit
...at the top of your module, it will catch most spelling issues.