adp update query with form input

how to build ADP update query with form input

1) create Access Data Project

2) create new form

3) build new stored procedure ‘spStoredProcedure’

create procedure spStoredProcedure


@Parameter1 varchar(50)



Select ProductID, ProductTitle

From Products

Where Description like '%' + @Parameter1 + '%'

4) add button using the Add Button wizard

5) add this code to your button_click event

Dim strSql as string

strSql = “EXEC spStoredProcedure @Parameter1=” & me.txtSearch.value
docmd.RunSql strSql

That’s all it takes, let me know if you need more help!

This entry was posted in SQL Server and tagged . Bookmark the permalink.