Current Record

[Prince]

Good day to you (everyone).
I developed several forms in my system. Most of my forms use Requery to dispay records that match user's rquest.
I need to make two text boxes one to show the current record position and the second to show the record count.
I made these two text boxes but I don't know how to let them dispaly the current record and record count.
I used in the data source
=currentrecord()
=recordcount()
and It didn't work
any suggestion for help?

 

[indesisiv]

I use an umbound text box and set it in the current even of the form.

Me.txtRecordNumber =  CurrentRecord & " of " & Me.RecordsetClone.RecordCount

Where txtRecordNumber is the name of the unbound text box.
Hope this helps

Steve