[AccessD] Position in bound recordset

Never mind.  Figured it out.


    Dim rs as Recordset 		
    Set rs = Me.Recordset
    Me.lblRecordXofY.Caption = "Patient " & rs.AbsolutePosition + 1 & " of "
& rs.RecordCount 

Unless there's a slicker way.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Sunday, October 05, 2008 9:54 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Position in bound recordset

Dear List
 
Is there a way to get the record number of the current record on a bound
form - that is, not the autonumber id but the position of the record - like
record 45 of 12,000?
 
MTIA
 
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com