Record Navigation

[Len B]

In the bottom left corner of most forms the current record number
and the record count shows something like this
Record 17 of 25

I need to use each of these numbers in VBA.
For the recordcount DCount("primarykey","tablename") seems to work.
Try as I might, I haven't been able to find how to determine what the
current rec num is.

I figure it has more to do with the form than the underlying table but
I can't find a useful form attribute.

Any ideas?

TIA

 

[RonaldoOneNil]

[CurrentRecord] is the name.

e.g. "The record is " & [CurrentRecord] & " of " &
DCount("primarykey","tablename")

 

[Len B]

Now why couldn't I find that?
Thanks Ronaldo
--
Len
______________________________________________________
remove nothing for valid email address.
| [CurrentRecord] is the name.
|
| e.g. "The record is " & [CurrentRecord] & " of " &
| DCount("primarykey","tablename")
|
| "Len B" wrote:
|
| > In the bottom left corner of most forms the current record number
| > and the record count shows something like this
| > Record 17 of 25
| >
| > I need to use each of these numbers in VBA.
| > For the recordcount DCount("primarykey","tablename") seems to work.
| > Try as I might, I haven't been able to find how to determine what the
| > current rec num is.
| >
| > I figure it has more to do with the form than the underlying table but
| > I can't find a useful form attribute.
| >
| > Any ideas?
| >
| > TIA
| >
| > --
| > Len
| > ______________________________________________________
| > remove nothing for valid email address.
| >
| >
| >

 

[Linq Adams via AccessMonster.com]

Or even simpler

"Record " & CurrentRecord & " Of " & RecordsetClone.RecordCount

 

[Len B]

Must be why cats need 9 lives.

--
Len
______________________________________________________
remove nothing for valid email address.
| Or even simpler
|
| "Record " & CurrentRecord & " Of " & RecordsetClone.RecordCount
|
| --
| There's ALWAYS more than one way to skin a cat!
|
| Answers/posts based on Access 2000/2003
|
|
|
|