I get the result I want in a Datagrid by using Recordset Sql:
Select * from MYQUERY Where (name Like 'WHATEVER*')
I change the name by retyping the whole line, substituting the new name,
typed into a long textBox named txt.Select, like this
Private Sub cmdSelect_Click()
Data1.RecordSource = txtSelect.Text
When try to use Select * From MYQuery Where ('name Like ' *')
and leave it in the TextBox, putting the next name in the space, nothing happens.
I want to put the names only in the textbox without retyping the whole line of sql to bring up the fields in my query.
Any offers of a few lines of helpful code would be much appreciated.