<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><STRONG>Don,</STRONG></DIV>
<DIV> </DIV>
<DIV> Current Record method can misfire if field
value in a sorted column has been updated. In such a situation use of bookmark
property is more common.</DIV>
<DIV> </DIV>
<DIV> Sometimes, even the use of bookmark property fails
to give consistent results. In such a case one might opt for navigating to the
desired record - using its primary key value.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><STRONG>A.D.Tejpal</STRONG></DIV>
<DIV><STRONG>--------------</STRONG></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=delliker@hotmail.com href="mailto:delliker@hotmail.com">Don
Elliker</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 21, 2003 20:57</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Remembering place
on a datasheet</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>
<P>I assume datasheet works like continuous form and if so, you can get the
CurrentRecord prop of the recordsource and save it. Then use the
docmd.gotorecord ,acgoto (I think) then the value you saved from the
CurrentRecord. You could also , depending on what your doing, save the
SelTop value and goto that.<BR>Ja?<BR>_D</P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things
are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Mike and Doris Manning" <MIKEDORISM@NTELOS.NET>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Remembering place on a datasheet
<DIV></DIV>>Date: Wed, 21 May 2003 10:20:45 -0400
<DIV></DIV>>
<DIV></DIV>>I have created a datasheet for my users that works really well.
The problem
<DIV></DIV>>is that some users may have about 200 lines on there sheet.
Whenever the
<DIV></DIV>>datasheet requeries, the record pointer floats back to the top
instead of
<DIV></DIV>>remaining on the line the user was working with.
<DIV></DIV>>
<DIV></DIV>>Anybody got any suggestions for how can I sneakily return the
user back to
<DIV></DIV>>line they were working on to get around the requery problem?
<DIV></DIV>>
<DIV></DIV>>Doris Manning
<DIV></DIV>>Database Administrator
<DIV></DIV>>Hargrove Inc.
<DIV></DIV>>www.hargroveinc.com
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></DIV><BR clear=all>
<HR>
Help STOP SPAM with <A href="http://g.msn.com/8HMEENUS/2731??PS=">the new MSN
8 </A>and get 2 months FREE*
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>