-
I am trying to using an input box that allows the users to search a particular string in a field and then have only those records display in the datagrid. However, what is happening is that all the records from the table are being displayed. I am using the datasource property to tell the grid what table I am using. Any help would greatly be appreciated!
-
are you passing the value of the input box to the adodc and doing a refresh?
myvalue = inputbox.text
mysql = "select * from mytable where myfield = '" & myvalue & "'"
adodc.recordsource = mysql
adodc.refresh
