is there anyone who knows how to pass on a variable value from one control on a form to a sql list query?
eg. exec some_stored_proc 'parameter'
the parameter being a previously selected value on a form. such as %date%
Hi Leon -
The only way to do it is via an add-in. (see attached movie)
Please submit this as an enhancement request if you get a chance.
Thank you Joy
The movie is cool. Where can I get the ADDIN or do I have to write it????
Though I hate typing as much as the next guy, all the code you would need for your addin can be seen in Scene I of Joy's movie.
Hi Guys -
I'll save you the typing :-)
But remember - this is just a code sample illustrating a solution.
It is NOT complete code. You need to modify and complete for your purposes.
This is provided AS-IS with no support :-)
Thank you Thank you Thank you
Retrieving data ...