Counting Records in a table

[Stan Denman]

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?

[Bob Fitz]

Try:
=DCount("*","verbs")
as the Record Source property of Text48. BTW IMHO it would be better to rename the text box with something more meaningful like txtVerbTotal.

[CJ_London]

think Bob means Controlsource for the textbox

[Bob Fitz]

Yes. Thank you Ajax. That was indeed what I meant. Not only knowledgeable but psychic too 😆

[Missinglinq]

Not sure what was going on...as your original code should work fine...as will Bob's...but have to ask about what, exactly, you're planning to do here.

Records in Access Tables do not actually have 'record numbers.' A Table is more like a bag full of marbles (to use a common comparison) moving around in no particular order.

Linq ;0)>

[orange]

As Linq has suggested, it might be helpful to you and readers if you told us in simple terms what you trying to accomplish.