<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=635022418-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Since I don't know what else the code was trying to do, I won't guess,
but if you delete a record, unless it's the last record, does it matter which
one you wind up on? Have you tried just commenting out that
line?</FONT></SPAN></DIV>
<DIV><SPAN class=635022418-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=635022418-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Judy Johnson
[mailto:jjwrite@earthlink.net] <BR><B>Sent:</B> Tuesday, May 20, 2003 10:19
AM<BR><B>To:</B> AccessD<BR><B>Subject:</B> [AccessD] Delete Record
Problem<BR><BR></FONT></DIV>
<P>
<DIV></DIV>
<DIV>Charlotte - I added your code as you explained and set the focus to one
of my data entry fields on the form and it deleted great. The next instruction
in the delete routine was DoCmd GoTo Record,,acnext However!! now I get No
Current Record error, no matter what I attempt to do. I can't move to another
record on my form. I've even closed Access and opened it up again but to no
avail.</DIV>
<DIV> </DIV>
<DIV>Thanks.</DIV>
<DIV> </DIV>
<DIV>Judy Johnson</DIV>
<DIV><A href="mailto:jjwrite@earthlink.net">jjwrite@earthlink.net</A></DIV>
<DIV>860-482-8651</DIV>
<DIV>860-309-2484 (cell)</DIV>
<DIV> </DIV>
<P></P></BLOCKQUOTE></BODY></HTML>