benu302000
Programmer
I have a form that displays results from a different "search" form. in this form, I would like to have a number for how many results were returned, any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
number of records on form 1
- Thread starter benu302000
- Start date
- Status
-
1
- #2
TheAceMan1
Programmer
How are ya benu302000 . . . . .
See Ya! . . . . . .
Code:
[blue] Public Sub recCnt()
Dim rst as DAO.Recordset
Set rst = Me.RecordsetClone
rst.MoveLast
Me![purple][b]TextBoxName[/b][/purple] = rst.RecordCount
Set rst = nothing
End Sub[/blue]- Status
Similar threads
