number of each record in a dataset

[Guest]

I need to know what the sequence number of a record is without refering to
the navigation bar, so that if records are deleted I can tell when browsing
what place number a record lies in out of the total. If I could interogate
the navigation bar all would be great.

 

[Allen Browne]

Not sure I followed the logic of why, by try the CurrentRecord property of
the form, or the AbsolutePosition property of a recordset.

This article might help:
What, no record numbers?
at:
http://allenbrowne.com/xbase-03.html

 

[Guest]

Thanks for the speedy response - I can not find the properties you mentioned,
perhaps because I didn't make it clear I was using Access2003.

My reasoning is that I want to switch of record navigation buttons when at
the first or last record of a set and I am using the total number of records
against current record number to achieve this.

 

[Guest]

I was too quick to respond Allen, Of course you refering to the VB code. It
is sorted out now, thanks for your help1

Hey I'm in Perth end of August this year for 2 weeks!

 

[Allen Browne]

Did you try usin the CurrentRecord property as suggested in the article?

It's not that difficult... like a single, short line to copy and paste.