<div>
This solution confirms I have to use passthrough query in code.
</div>


This solution confirms I have to use passthrough query in code.

<div>
<div class="content wysiwyg-content">
I am using an ACCDB database to connect to a MS SQL Server database using an ODBC connection. I can link the tables in SQL Server. However, I can only use the functions and procedure in MS SQL Server database when using a pass-through query. &nbsp;How can I define the functions and store procedure input parameters which can be linked to the controls on the forms (which is like the Build tool for normal query)? 
</div>
</div>


I am using an ACCDB database to connect to a MS SQL Server database using an ODBC connection. I can link the tables in SQL Server. However, I can only use the functions and procedure in MS SQL Server database when using a pass-through query.  How can I define the functions and store procedure input parameters which can be linked to the controls on the forms (which is like the Build tool for normal query)? 

How can I define the functions and store procedure input parameters which can be linked to the controls on the forms?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.