[AccessD] Row number in form

Hi all

If you in a form wish to store a row number in records added, I found an extremely simple method I haven't seen anywhere else:

  Private Sub Form_BeforeInsert(Cancel As Integer)
    Me!RowNo.Value = Me.CurrentRecord
  End Sub

Of course, in a multi-user environment, this must somehow be isolated for a single user's entries. 

/gustav