[AccessD] Row number in form

Susan Harkins ssharkins at gmail.com
Tue Jan 22 08:59:32 CST 2008


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
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list