<!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 5.50.4916.2300" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>My colleague ran
across a strange problem in Access 2000, and I can't seem to find anything on
any of the reference sites that mention this behavior:</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>Created an
append query that references form controls as it's criteria (start/end
dates).</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>Set a breakpoint in
the command button event procedure.</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>With the code in
break mode, he tried opening the query manually, and no records were
returned.</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>After a little
troubleshooting, we found that the referenced form control values disappear in
the query if the form's code is in break mode!</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>What a PITA!
Has anyone else run across this problem?</FONT></SPAN></DIV>
<P><FONT face=Arial size=2>Brett Barabash, MCP <BR>Tappe Construction, Co.
<BR>Eagan, MN <BR>bbarabash@tappeconstruction.com <BR>(651) 256-6831 </FONT></P>
<P><FONT face=Arial size=2>"Computer games don't affect kids; I mean if Pac-Man
affected us as kids, we'd all be running around in darkened rooms, munching
magic pills and listening to repetitive electronic music." - Kristian Wilson,
Nintendo, Inc., 1989.</FONT></P>
<DIV> </DIV><br><br>--------------------------------------------------------------------------------------------------------------------<br>This email and any files transmitted with it are confidential and<br>intended solely for the use of the individual or entity to whom<br>they are addressed.<br>If you have received this email in error please notify the<br>originator of the message. This footer also confirms that this<br>email message has been scanned for the presence of computer viruses.<br><br>Any views expressed in this message are those of the individual<br>sender, except where the sender specifies and with authority,<br>states them to be the views of Tappe Construction Co.<br><br>Scanning of this message and addition of this footer is performed<br>by SurfControl E-mail Filter software in conjunction with <br>virus detection software.<br></BODY></HTML>