[AccessD] How do I pass a control to a function in the ControlSource

I'm bite, how does the function know which control to return the value to in the absence of Screen.ActiveControl?  How is this handled in the function?  I'm not sure why you are implying that this 'need' is a bad thing as it certainly will work 100% of the time in a control's double click event.  If there's a better way, I'm open to suggestions.

Ciao 

Jürgen Welz 

Edmonton, Alberta 

jwelz at hotmail.com


 
> From: max.wanadoo at gmail.com
> To: accessd at databaseadvisors.com
> Date: Wed, 30 Sep 2009 23:42:07 +0100
> Subject: Re: [AccessD] How do I pass a control to a function in the ControlSource
> 
> I use something very similar, again from way back with Getz etc.
> 
> On the form property against the d/click I put =popcal(True) or
> =popcal(False)
> To indicate if the user can change the date or note.
> The calendar form then opens with the existing date in the text box passed
> through (no need for screen.active.control) that is handled in the function.
> 
> Zero over heads and NO problems with it being called DIRECTLY from the form.
> 
> Max
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen Welz
> Sent: 30 September 2009 23:34
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] How do I pass a control to a function in the
> ControlSource
> 
> 
> I use a standard textbox control for dates throughout all applications.
> Double click the textbox and it pops my calendar and passes a reference to
> .... 
> 
> 
> =fnSetDate(Screen.ActiveControl) 		 	   		  
_________________________________________________________________
Windows Live helps you keep up with all your friends, in one place.
http://go.microsoft.com/?linkid=9660826