Get record number from record navigator

[Guest]

I am using Office 2003 on Windows XP.

I have the navigation control showing on a form so the user can scroll
through records. Using VBA, is it possible to return the current position or
record number that is shown on that built-in control?

If so, could someone please post example VBA?

Thanks again, in advance.

 

[Bob L.]

The CurrentRecord property of a form returns the record number. So if your
code is on that form you can simply use me.currentrecord. If elsewhere use
forms("formname").current record. Search current record in VBA help for
example.

HTH
Bob L