record count on forms

  • Thread starter Thread starter judith
  • Start date Start date
J

judith

Is there any way to set up your own count fields on a
form. The number of records in the display set I can
manage but I would like to display (2 of 5) rather than
just (5)

Thanks
 
Experiment with this:

Private Sub Form_Current()
ctlRecordno = Me.SelTop
End Sub

ctlRecordno is an unbound control (text field in my test) in the form
header.
 
Hi Judith

In a textbox, simply enter the following:

=[CurrentRecord] & " of " & [RecordsetClone].[RecordCount]

Maurice
 
StCyrM said:
Hi Judith

In a textbox, simply enter the following:

=[CurrentRecord] & " of " & [RecordsetClone].[RecordCount]
Click to expand...

Hey, didn't know that property. Interesting, thanks. (Funny that my
higher level of codeing experience often hides simpler solutions from me)
 
Terrific, thanks...
-----Original Message-----
Hi Judith

In a textbox, simply enter the following:

=[CurrentRecord] & " of " & [RecordsetClone]. [RecordCount]
Maurice

Is there any way to set up your own count fields on a
form. The number of records in the display set I can
manage but I would like to display (2 of 5) rather than
just (5)
Click to expand...


.
Click to expand...
 
Back
Top