Hi Mike,

I should restate, previewing the data works fine but creating the dataset gives the error "Retreiving the schema for Oledbdataadapter1 failed! No value given for one or more parameters." I removed the parameters from the Select statement and it allows me to create the dataset, then I added the parameters back to the Select statement. At that point all seems well.

Then I added a textbox (textbox1) and button on the form and added this code to the button click event:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'OleDbDataAdapter1.SelectCommand.Parameters("hinit").Value = TextBox1.Text
OleDbDataAdapter1.SelectCommand.Parameters("hinit").Value = "BWP"
DsHoa1.Clear()
OleDbDataAdapter1.Fill(DsHoa1)
DataGrid1.DataBind()
End Sub


Notice that I tried hard coding the parameter value. I cannot get a parameterized search to work from the click event. If I remove the parameter from the select statement, it will load and display the entire table just fine.

So close and yet so far...

Todd