<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=015362111-30052003><FONT face=Arial color=#0000ff size=2>That's
an additional reason why I dislike going that route. The query then becomes
useless in the absence of said form being open. Static functions are IMO a much
better way to go.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=015362111-30052003><FONT face=Arial color=#0000ff size=2>Just
my $.02,</FONT></SPAN></DIV>
<DIV><SPAN class=015362111-30052003><FONT face=Arial color=#0000ff
size=2>Arthur</FONT></SPAN></DIV><!-- Converted from text/plain format -->
<P><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Charlotte
Foust<BR><B>Sent:</B> May 29, 2003 11:00 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Query reference to
screen control<BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=880255814-29052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Parameters referring to form controls work just fine. Only make
sure you put in the square brackets around each part of the parameter
yourself. Otherwise, when/if you convert to 2002, you can run into
problems when the query engine kindly inserts its own brackets around the
whole blasted parameter. Hello? This is the voice of experience
speaking ...</FONT></SPAN></DIV>
<DIV><SPAN class=880255814-29052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=880255814-29052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE 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> Don Elliker
[mailto:delliker@hotmail.com] <BR><B>Sent:</B> Thursday, May 29, 2003 5:16
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] Query reference to screen control<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>Hmmmm, that's a twist. Does it then not pop up the parameter dialog
because I would be referring to the screen control?...I will give it a go,
and thanks Gustav.<BR>_d<BR></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: Gustav Brock <GUSTAV@CACTUS.DK>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: Re: [AccessD] Query reference to screen control
<DIV></DIV>>Date: Thu, 29 May 2003 12:53:47 +0200
<DIV></DIV>>
<DIV></DIV>>Hi Don
<DIV></DIV>>
<DIV></DIV>>Try specifying in the query
[forms]![frmtestcases]![cmbproject] as a
<DIV></DIV>>parameter.
<DIV></DIV>>
<DIV></DIV>>/gustav
<DIV></DIV>>
<DIV></DIV>> >I have this odd occurrance in A2K. I have a combo that
has criteria
<DIV></DIV>> >referencing two screen controls, like this
<DIV></DIV>> >[forms]![frmtestcases]![cmbproject]. Many times (but not
always) it
<DIV></DIV>> >returns nothing when I click it. Then if I go into the
grid for the
<DIV></DIV>> >underlying query and make it
<DIV></DIV>> >=[forms]![frmtestcases]![cmbproject] it works, however
it does not keep
<DIV></DIV>> >the equal sign, it discards it - works for a while then
craps out. What
<DIV></DIV>> >gives?? Just another wierd Accessism?
<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>
MSN 8 helps <A href="http://g.msn.com/8HMJENUS/2752??PS=">ELIMINATE E-MAIL
VIRUSES.</A> Get 2 months FREE*. </BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>