How to display no. of record instead of using Navigation Buttons? 2

[awinnn]

Hi,
Do you know how to display number of record in the form?
As for example, i have 10 records. Let say i'm editing 2nd. record, so..it should be 2 of 10 records on the bottom of the form.
In this case, i don't want to use Navigation Button. Any idea?
Thanx a lot..

 

[RoyVidar]

Hi!

For currentrecord, it should suffice with using:

[tt]=currentrecord[/tt]

as controlsource of a textbox.

For number of records, perhaps in the on current event of the form:

[tt]me!txtNumOfRecs.value=me.recordsetclone.recordcount[/tt]

Note - the currentrecord would show one record more than the recordcount when at a new record

HTH Roy-Vidar

 

[jdttek]

To show # of records, simply put =Count(*)as recordsource of txt box. Use Wizard to add previous, next, last record, etc.

Thanks Roy-Vidar on how to get record #. I was trying to figure out the same thing. Assume this adjusts for filtered records as will?


JDTTEK.

 

[RoyVidar]

Hi jdttek,

both of my suggestions will consider only the records in the forms recordset -> just the forms recordset, filtered or not.

Roy-Vidar

 

[awinnn]

Hi RoyVidar and jdttek,

thanx for your help....it works...

star for both of you..

 

[RoyVidar]

Thanx, both for the kind words, and the star!

Glad to be of assistance! Roy-Vidar