[AccessD] Remembering place on a datasheet

What is triggering the requery?  The way I generally do this in forms is
to store the key for that record in a variable and then after the
requery, I use recordsetclone navigation to set the bookmark back to the
record they were on.  I believe bookmarks get reshuffled in a requery,
because I've never been able to make using them that way work.

Charlotte Foust

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Wednesday, May 21, 2003 6:21 AM
To: AccessD at databaseadvisors.com
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