Populating checkbox based on combobox selection

[shortone]

I have a checkbox that I would like to be checked automatically when a district that is found on a particular query is selected from a combobox. I'd written code on the AfterUpdate event of the District Code, but I'm not referring to the query correctly and can't seem to remember the correct syntax. Here's what I have - someone please correct my error, thanks!


Private Sub DistCode_AfterUpdate()
If Me!DistCode=DistCode("AbbottDistList"Name of query) Then
Abbott.Value=True
Else
Abbott.Value=False
End if
End Sub

 

[shortone]

Hi again!

I got the answer to this question in another forum (it works perfectly!) and would like to share it with everyone here:

Private Sub DistCode_AfterUpdate() 

  If IsNull(DLookup("[DistCode]","AbbottDistList","DistCode = " & ME!DistCode) = False Then 

   Abbott.Value=True 

   Else 

   Abbott.Value=False 

  End if
End Sub

Hope this helps someone else with the same problem!