Check Box Values

Hello,
I have a table with a yes/no field and on the form i have a checkbox that refers to that field. I am trying to count the number of records where that box is checked. This is the code i have so far

Code: Dim rs As Recordset Dim db As Database Dim i i = 0 Set db = CurrentDb() Set rs = db.OpenRecordset("Listings") 'table im pulling from rs.MoveFirst Do Until rs.EOF If me.Check137 Then i = i + 1 End If rs.MoveNext Loop MsgBox i
When i run the code, the check box returns a value of -1 for each run through the loop. Out of 900 records, i only have 4 of these boxes checked and they arent being counted. Instead, it returns a value of the number of records in the table. Am I missing something simple here?