G
Guest
I have a form that on it has a list box (lstClaimNumber) and below it there
is a label (lblClaimCount) to say how many claim numbers there are in the
listbox. Below is the sql statement that is used to fill the listbox. The 2
lines below the sql statement do the counting. Currently, the table has 3381
records in it. I even moved it to an excel sheet to make sure. When an
"All" button is selected, these lines run. But the label will report back
3253 as the number of records. It is 128 difference. I am at a loss as to
why. Can anyone see any error in the lines below?
Thanks to anyone responding.
*** John
Me.lstClaimNumber.RowSource = _
" SELECT " & _
" SurveyResponseID, " & _
" Month, " & _
" Year, " & _
" ClaimNumber " & _
" FROM tblSurveyResponses " & _
" WHERE (((ClaimNumber) > 0)) " & _
" ORDER BY ClaimNumber;"
Me.lstClaimNumber = Me.lstClaimNumber.ItemData(0)
Me.lblClaimCount.Caption = lstClaimNumber.ListCount & " total surveys"
is a label (lblClaimCount) to say how many claim numbers there are in the
listbox. Below is the sql statement that is used to fill the listbox. The 2
lines below the sql statement do the counting. Currently, the table has 3381
records in it. I even moved it to an excel sheet to make sure. When an
"All" button is selected, these lines run. But the label will report back
3253 as the number of records. It is 128 difference. I am at a loss as to
why. Can anyone see any error in the lines below?
Thanks to anyone responding.
*** John
Me.lstClaimNumber.RowSource = _
" SELECT " & _
" SurveyResponseID, " & _
" Month, " & _
" Year, " & _
" ClaimNumber " & _
" FROM tblSurveyResponses " & _
" WHERE (((ClaimNumber) > 0)) " & _
" ORDER BY ClaimNumber;"
Me.lstClaimNumber = Me.lstClaimNumber.ItemData(0)
Me.lblClaimCount.Caption = lstClaimNumber.ListCount & " total surveys"