Alternative to AbsolutePosition?

[snorkyller]

Which is the best method to know, in the code, the actual position of the record showed by a form? For example if there are 12 records and the form is actually displaying the 3rd record, I need to get the number 3.



Me.Recordset.AbsolutePosition doesn't seem a good solution 'cause it is often equal to -1. For example, after deleting a record or modifying the .RecordSource property of the form. This lead to errors. Even after moving the current record with DoCmd.GoToRecord, .AbsolutePosition sometimes stay to -1. So it is sometimes impossible to know in the Form_Current event what is the current record.

Thank you for your suggestions...

[ajetrumpet]

if you make the navigation button visible on forms, you can read it right off of the screen.

[snorkyller]

if you make the navigation button visible on forms, you can read it right off of the screen.

(?!)
I know that!
It's in the code that need to know the current record number.

[ajetrumpet]

the code to get the record number in a form is simply:

me.currentrecord

[snorkyller]

Yeah very simple! I wonder why I didn't find it before. I was using Me.Recordset.AbsolutePosition...

I wish it doesn't also return -1 sometimes...

Thanks a lot!