Displaying Record Number on Form

[Mike]

I need to display the record number on a form - replacing the Access
Navigation Buttons.

I found a routine on Access Web that is supposed to work but when I use it I
am told that "Object doesn't support this property or method"

The code it uses is placed on the on Current Event and is as follows:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.lblNavigate.Caption = "Record " & _
.CurrentRecord _
& " of " & .RecordCount
End With

This produces the error...

I am using Access 2002. Is there a way to do this in Access 2002?

Mike

[Wayne Morgan]

Newer versions of Access have exposed the form's recordset so that you can use it directly
instead of creating a clone first.

Me.lblNavigate.Caption = "Record " & _
Me.CurrentRecord & " of " _
Me.Recordset.RecordCount

--
Wayne Morgan
Microsoft Access MVP
"Mike" <re******@hotmail.com> wrote in message news:3f******@dnews.tpgi.com.au...

I need to display the record number on a form - replacing the Access
Navigation Buttons.

I found a routine on Access Web that is supposed to work but when I use it I
am told that "Object doesn't support this property or method"

The code it uses is placed on the on Current Event and is as follows:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.lblNavigate.Caption = "Record " & _
.CurrentRecord _
& " of " & .RecordCount
End With

This produces the error...

I am using Access 2002. Is there a way to do this in Access 2002?

Mike

[Mike]

Thanks Wayne... works a treat.

Mike

"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:vg******************@newssvr31.news.prodigy.c om...

Newer versions of Access have exposed the form's recordset so that you can use it directly instead of creating a clone first.

Me.lblNavigate.Caption = "Record " & _
Me.CurrentRecord & " of " _
Me.Recordset.RecordCount

--
Wayne Morgan
Microsoft Access MVP
"Mike" <re******@hotmail.com> wrote in message

news:3f******@dnews.tpgi.com.au...

I need to display the record number on a form - replacing the Access
Navigation Buttons.

I found a routine on Access Web that is supposed to work but when I use it I am told that "Object doesn't support this property or method"

The code it uses is placed on the on Current Event and is as follows:

With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me.lblNavigate.Caption = "Record " & _
.CurrentRecord _
& " of " & .RecordCount
End With

This produces the error...

I am using Access 2002. Is there a way to do this in Access 2002?

Mike