Are you looking for a Pass-Thru query (like SQL server) or a Parameter Query?

CREATE PROCEDURE statement

I show an example of how to get user parameters from a form and then dynamically write the pass-thru query in the Access SQL Server Seminar.

Hello Everyone,

Appreciate the response. I am looking for a way to add a user entered parameter to a Pass-Thru query. Create Procedure statement certainly looks like it will work.

Thanks Again,
Joe

Hello Guys,

Went back and re-watched Lesson 4 of the SQL Server Seminar. Used an Input Box to set the Jurisdiction Name instead of a text box on a form. Works just fine. Your help if very much appreciated.

Thanks,
Joe

Awesome... although a form field should have worked just fine too.