[AccessD] Remembering place on a datasheet

Doris:

DIM varBookMark as Variant

    varBookMark = Me.Bookmark
    Me.Requery (or whatever)
    Me.Bookmark = varBookMark

will return you to the original record.

HTH

Rocky Smolin
Beach Access Software

----- Original Message ----- 
From: "Mike and Doris Manning" <mikedorism at ntelos.net>
To: <AccessD at databaseadvisors.com>
Sent: Wednesday, May 21, 2003 7:20 AM
Subject: [AccessD] Remembering place on a datasheet


> I have created a datasheet for my users that works really well.  The
problem
> is that some users may have about 200 lines on there sheet.  Whenever the
> datasheet requeries, the record pointer floats back to the top instead of
> remaining on the line the user was working with.
>
> Anybody got any suggestions for how can I sneakily return the user back to
> line they were working on to get around the requery problem?
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com