Record X of Y

[Guest]

I saw a previous posting relating to this but I couldn't get the response to work. I would like to replace a form's navigation buttons with custom buttons and add a label that will display something like "Record X of Y". The form's recordsource is a table. I can get the number of records using Me.RecordsetClone.RecordCount, but as for the number of the currently displayed record I am at a loss.

I tried this from a previous posting in the form's on Current() event - Me!LblRecord.Caption = Me.RecordCount & " Of " & Count([IDPartNo]) but get an error "Method or Data member not found on the me.recordCount

Any help would be much appreciated

Bo

 

[Mark]

Put the following code in your form's OnCurrent event:

Me!LblRecord.Caption = "Record " & Me.CurrentRecord & " Of " &
Me.RecordsetClone.RecordCount

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I saw a previous posting relating to this but I couldn't get the response to

work. I would like to replace a form's navigation buttons with custom buttons
and add a label that will display something like "Record X of Y". The form's
recordsource is a table. I can get the number of records using
Me.RecordsetClone.RecordCount, but as for the number of the currently displayed
record I am at a loss.

I tried this from a previous posting in the form's on Current() event -

Me!LblRecord.Caption = Me.RecordCount & " Of " & Count([IDPartNo]) but get an
error "Method or Data member not found on the me.recordCount"

 

[Guest]

Thanks very much Mark

It works perfectly

Bob Mullen