Hello,
I use the following subroutine to populate record number into a field on a continuous form. I've tried to put this code behind a button on the form and test it as I add more records to the form. It seems not to work well. Could someone please suggest another method?
thanks,
Mila
I use the following subroutine to populate record number into a field on a continuous form. I've tried to put this code behind a button on the form and test it as I add more records to the form. It seems not to work well. Could someone please suggest another method?
Code:
Dim rs As DAO.Recordset
Set rs = Me.Recordset
Do While Not rs.EOF
rs.Edit
Debug.Print rs.AbsolutePosition
rs!supporting_text = rs.AbsolutePosition + 1
'Debug.Print rs.AbsolutePosition + 1
rs.Update
rs.MoveNext
Loop
rs.MoveFirst
thanks,
Mila