[AccessD] Row number in form

Hi Susan

It does, in fact it _is_ that record number.

You can use it in a multi-user environment if you don't rely on it as a kind of unique Id as you may get duplicate entries in the table behind for this field.

/gustav

>>> ssharkins at gmail.com 22-01-2008 15:59:32 >>>
So, this displays a record number, similar to the form's navigational 
toolbar? I'm not why you'd need anything extra in a multi-user 
environment -- wouldn't this rely on the form's recordset and not the data 
source?

Susan H.


> 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