snorkyller
03-03-2011, 10:34 PM
Which is the best method to know the actual position of the record showed by a form?
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...
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...