Reverse function of yes/no check boxes

[dwcrockford]

I have seen many posts (here and elsewhere), where you can use an iif statement based on whether a checkbox is marked true/false (yes/no, 0/1).

Is there a way to have the checkbox toggle on/off based on the value of another object.

In this instance the two objects involved are:

checkbox (yes/no)
Location - based on a drop down (different table) listing countries.

What I want is if the country "Canada" is selected out of the drop down options, I want the checkbox to switch to "true" (on).

Both objects are located in the same table. "Locations" are a linked lookup table.

I've tried every variance of an iif statement but none work.

 

[Micron]

I try not to use IIF statements too much, especially when there's an event that fits the bill perfectly. Use the AfterUpdate event of the combo (with your control names of course):
If Me.Combo = "Canada" Then
Me.Check = True
Else
Me.Check = False
End If

 

[Marbles]

Private Sub Location_AfterUpdate()

If Me.Location = "Canada" Then Me.Checkbox = True

End Sub

Seems to work okay.