record count on forms

[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

 

[Bas Cost Budde]

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.

 

[StCyrM]

Hi Judith

In a textbox, simply enter the following:

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

Maurice

 

[Bas Cost Budde]

Hi Judith

In a textbox, simply enter the following:

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

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

 

[Judith]

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)

.