Arthur Fuller
artful at rogers.com
Fri May 30 06:22:54 CDT 2003
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. Just my $.02, Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: May 29, 2003 11:00 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Query reference to screen control 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 ... Charlotte Foust -----Original Message----- From: Don Elliker [mailto:delliker at hotmail.com] Sent: Thursday, May 29, 2003 5:16 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Query reference to screen control 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. _d "Things are only free to the extent that you don't pay for them." >From: Gustav Brock >Reply-To: accessd at databaseadvisors.com >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] Query reference to screen control >Date: Thu, 29 May 2003 12:53:47 +0200 > >Hi Don > >Try specifying in the query [forms]![frmtestcases]![cmbproject] as a >parameter. > >/gustav > > >I have this odd occurrance in A2K. I have a combo that has criteria > >referencing two screen controls, like this > >[forms]![frmtestcases]![cmbproject]. Many times (but not always) it > >returns nothing when I click it. Then if I go into the grid for the > >underlying query and make it > >=[forms]![frmtestcases]![cmbproject] it works, however it does not keep > >the equal sign, it discards it - works for a while then craps out. What > >gives?? Just another wierd Accessism? > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _____ MSN 8 helps ELIMINATE E-MAIL <http://g.msn.com/8HMJENUS/2752??PS=> VIRUSES. Get 2 months FREE*. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030530/f155ff0f/attachment-0001.html>