SQL Server Scalar UDF as report textbox controlsource
Posted on 2013-01-10
I have a Scalar UDF in SQL Server that returns a single value for a passed parameter.
I have an MS Access mdb that uses that links to the SQL Server.
I have a report where I want to bind a textbox to the UDF. Is that possible?
If not, how would I write a VBA function that calls the UDF and returns the value?
While waiting for an answer, I am going to look to see if I'm able to just include the UDF in the SQL Server recordsource that the report is already using. That would be a much cleaner solution. But, in case I can't do that, I'd like an answer to the above.