I have a sub-form which is a continous form. Next to each record, I want to display each unique record number (as found with Me.CurrentRecord). To display the record number I am using a text box. Here is the code:
Private Sub Form_Current()
txtRecordNumber = Me.CurrentRecord
This works, however, instead of displaying each records record number, it displays the one record number in all instances of txtRecordNumber for the record which currently has the focus. So, if record 1 has the focus, then it displays a '1' in each records RecordNumber text box. Is there a way to resolve this?