<!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=564015014-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Actually, what I encountered had nothing to do with the form being
open. In earlier versions, the query engine understood the syntax without
square brackets around things like Column(0), but in AXP, any missing brackets
will cause it to put a pair of square brackets around the whole parameter,
rendering it completely useless even with the form open.</FONT></SPAN></DIV>
<DIV><SPAN class=564015014-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=564015014-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2>I don't much like using form references as parameters or criteria, but
our applications make extensive use of them that way in report selection.
</FONT></SPAN></DIV>
<DIV><SPAN class=564015014-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=564015014-30052003><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> Arthur Fuller
[mailto:artful@rogers.com] <BR><B>Sent:</B> Friday, May 30, 2003 3:23
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Query reference to screen control<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>