DataGrid using ADO

[ACN1234]

I am using an input box to allow the users to enter a string that they want to search on. Then it will pull up a datagrid with selected records based on the searchcriteria. The problem that I am having is that it is pulling all the records from the table. I am using Access and ADO. Any help in getting this to work is greatly appreciated.
Thanks

[barrk]

datagrid.datasource = adodc
myvalue = inputbox.text
mysql = "select * from mytable where myfield = '" & myvalue & "'"
adodc.recordsource = mysql
adodc.refresh