CurrentRecord Property [Access 2003 VBA Language Reference]
You can use the CurrentRecord property to identify the current record in the recordset being viewed on a form. Read/write Long.
expression Required. An expression that returns one of the objects in the Applies To list.
Microsoft Access sets this property to a Long Integer value that represents the current record number displayed on a form.
The value specified by this property corresponds to the value shown in the record number box found in the lower-left corner of the form.
The following example shows how to use the CurrentRecord property to determine the record number of the current record being displayed. The general-purpose CurrentFormRecord procedure assigns the value of the current record to the variable
Sub CurrentFormRecord(frm As Form) Dim lngrecordnum As Long lngrecordnum = frm.CurrentRecord End Sub
See Also | NewRecord Property