Record X of Y

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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




Bob Mullen said:
I saw a previous posting relating to this but I couldn't get the response to
Click to expand...
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 -
Click to expand...
Me!LblRecord.Caption = Me.RecordCount & " Of " & Count([IDPartNo]) but get an
error "Method or Data member not found on the me.recordCount"
 
Back
Top