<!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 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Brett:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Are you referencing the control directly in the
criteria line of the QBE - Forms!frmXyz!ctl123? I can't remember why but I
always had such trouble getting values from controls off of forms and into my
queries that I changed the criteria to reference a global function which returns
the value of the control. Maybe that will dodge around the problem instead
of solving it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>HTH,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=BBarabash@tappeconstruction.com
href="mailto:BBarabash@tappeconstruction.com">Brett Barabash</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:'accessd@databaseadvisors.com'">'accessd@databaseadvisors.com'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 10, 2003 2:12
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] A2K: Query parameters
disappear in break mode</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>