<!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=959185014-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2>I haven't taken the time to figure out exactly what those two archaic
lines say, but I can tell you what's happening. You're deleting the table
rather than the record. If you want to delete a record, just use
this:</FONT></SPAN></DIV>
<DIV><SPAN class=959185014-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=959185014-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2>DoCmd.RunCommand acCmdDeleteRecord</FONT></SPAN></DIV>
<DIV><SPAN class=959185014-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=959185014-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2>First, you will want to set the focus back to a data control just to keep
Access from getting confused.</FONT></SPAN></DIV>
<DIV><SPAN class=959185014-20052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=959185014-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 3:39
AM<BR><B>To:</B> AccessD<BR><B>Subject:</B> [AccessD] A97 Strange Delete
Behavior<BR><BR></FONT></DIV>
<P>
<DIV></DIV>
<DIV>I'm having a very strange thing occur. Not sure what's going on.</DIV>
<DIV> </DIV>
<DIV>My application consists of a FE and BE. I'm linking properly and my
tables are being updated as expected. However; I added a Delete button to a
data entry form and used the Wizard - Delete Record.</DIV>
<DIV> </DIV>
<DIV>When I launch the delete button the record doesn't get deleted, but the
link to the table, which is the table that the data source SQL statement
is based on, gets deleted. I've used this wizard many times before and have
never had a problem. I'm stumped!</DIV>
<DIV> </DIV>
<DIV><STRONG>Code that got produced by the wizard</STRONG>:</DIV>
<DIV> Private Sub CmdD_Click()<BR> On
Error GoTo Err_CmdD_Click</DIV>
<DIV><BR> DoCmd.DoMenuItem acFormBar, acEditMenu, 8, ,
acMenuVer70<BR> DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ,
acMenuVer70</DIV>
<DIV> </DIV>
<DIV>Exit_CmdD_Click:<BR> Exit Sub</DIV>
<DIV> </DIV>
<DIV>Err_CmdD_Click:<BR> MsgBox
Err.Description<BR> Resume
Exit_CmdD_Click<BR> <BR>End Sub<BR></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>