[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 VIRUSES.
<http://g.msn.com/8HMJENUS/2752??PS=>  Get 2 months FREE*. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030529/3d4b5e22/attachment-0001.html>