<html><div style='background-color:'><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*.</html>