CheckBox Update

[dungstar]

I have a "Location" combo box with a list of location. Each location has a boolean "Exist" field. I'm trying to get it so when I select the location, the "Exists" check box is checked if the location table shows record that something Exists in that Location, and not checked if the opposite is true.

I have a query that the checkbox is associated with, but it does not update the check box. I tried this line in the
Private Sub cboLocation_AfterUpdate():
Me!chkExistLoc.Requery
but I guess it only works with comboboxes.

Please help, thank you!

 

[Jack Cowley]

Private Sub cboLocation_AfterUpdate():
Me![cboLocation] = -1 Then
Me![chkExistLoc] = -1
Else
Me![chkExistLoc] = 0
End if
Exit Sub