<html><div style='background-color:'><DIV>
<P>Agreed. -depends on what you are doing.<BR>_d</P></DIV>
<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: "A.D.Tejpal" <AD_TP@HOTMAIL.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: Re: [AccessD] Remembering place on a datasheet
<DIV></DIV>>Date: Thu, 22 May 2003 00:05:01 +0530
<DIV></DIV>>
<DIV></DIV>>Don,
<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>>A.D.Tejpal
<DIV></DIV>>--------------
<DIV></DIV>> ----- Original Message -----
<DIV></DIV>> From: Don Elliker
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Sent: Wednesday, May 21, 2003 20:57
<DIV></DIV>> Subject: Re: [AccessD] Remembering place on a datasheet
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> 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.
<DIV></DIV>> Ja?
<DIV></DIV>> _D
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> "Things are only free to the extent that you don't pay for them."
<DIV></DIV>> >From: "Mike and Doris Manning"
<DIV></DIV>> >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> >To:
<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></DIV>>
<DIV></DIV>>------------------------------------------------------------------------------
<DIV></DIV>> Help STOP SPAM with the new MSN 8 and get 2 months FREE*
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>------------------------------------------------------------------------------
<DIV></DIV>>
<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></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/8HMDENUS/2731??PS=">the new MSN 8 </a> and get 2 months FREE*</html>