<html><div style='background-color:'><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*</html>