Access XP: Creating total records from table

  • Thread starter Thread starter Think
  • Start date Start date
T

Think

I want to build a new field based on field START_TIME (1.12.2003 1:37:32)
called TOTAL_NUMBER_OF_CALLS. In this field I want to have a number of total
records. That number I see at the bottom of the page (navigation buttons).
Thanks in advance.
 
If by "new field" you mean a text box on the form, use the following code in
the form's Current event:

Private Sub Form_Current()
Me.txtCount = Me.RecordsetClone.RecordCount
End Sub

where txtCount is the new text box.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top