Refresh Grid based on variable in where clause

[jallen919]

I have a form to search for customers based on last name. The user types the name in the text box and clicks on the search button. There is a data grid attached to an adodc. I want to know how to assign the value typed in the text box to a variable that is inserted into the where clause of a select statement. Then that recordset populate the adodc which should update the data grid?

Sound as confusing as I feel Any help is appreciated.