<!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=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></BODY></HTML>