Number Of records (2002(XP))

Topic

New Reply

I want to create a field on a form that will display the total number of records. I am in popup and don’t want to use the record indicator with nav buttons that is built in

Reply | Quote

Replies

I’m not clear on your pop-up reference’s effect, but in general:
On the form, place an unbound textbox with the following Control Source: =Count([Your key field])
That will display the number of records in the source that the form is based on.

Reply | Quote

That worked great. Thank You. Could I also make a text box that displayed the current record #

Reply | Quote

I have not done this before, but I did find Record Navigation Sample. It sounds as if it may contain the functionality you are looking for.

Reply | Quote

Are you using DAO or ADO? The download from Roger’s website uses DAO, and in AXP that would require your setting a DAO reference before you could use that approach. Using and ADODB recordset, you can do it like this:

Private Sub SetRecordNum()
  'Reset the "# of #" displayed in the form footer
  Me.txtRecNum = CStr(mrst.AbsolutePosition) & " of " & mlngRecCount
End Sub

In this case, txtRecNum is the name of an unbound textbox in the form footer that displays the current record number, mlngRecCount is a module level variable that holds the total number of records in the recordset, and mrst is the ADODB recordset object. The sub gets called from various routines in the form to keep the textbox in sync with the position in the recordset.

Reply | Quote