I need to count the records in a table programatically in a table. I have a table, "Verbs", and I have a form in which I have an unbound text box names text48. Table "Verbs" has 200 records. Table "verbs" is the datasource for a subform. I want filter what records in the subform gets displayed by the record number. Here is the code for a click event on form.
Private Sub cmdVerb_Click()
Dim db As Database
Dim Upper As Integer
Set db = CurrentDb
Upper = db.OpenRecordset("Verbs").RecordCount
Text48.Value = Upper
End Sub
The value I get in text48? 826. How in the world could this have happened with a table of 200 records?