Hi There,
I'm using Visual basic .net form to send in retrieve information from my access table.
I have created a oledbdataadapter with the following query

SELECT [WO #], [Dash #], Req AS [Order DT], Approved, Code, [Item#], Cus, ID
FROM Approve
WHERE ([WO #] between ? and ?)

I want to be able to input a Wo # between a range like between 13500 to 13600 etc.
I have two text box in my form and a button . Please find my code to the onclick event of the button.
I want to be able to pass the wo# from two text box.
I would appreciate if somebody can tell me how I could do this.

Private Sub ORDBTN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ORDBTN.Click
        Try
            OleDbDataAdapter1.SelectCommand.Parameters("WO__") .Value = OTBOX.Text
' somehow want to be able to send the second value for WO USING OTEND.TEXT( thats my second text box)
            FnApp()
        Catch ex As Exception
            MsgBox(ex.Message + vbCrLf + ex.Source & vbCrLf & vbCrLf & ex.StackTrace, MsgBoxStyle.Critical, "Error")
        End Try
    End Sub

I may be wrong but try this

u have to use oledbCommand object(let myCommand) then add following code

myCommand.Parameters.Add("@a",TextBox1.text)
myCommand.Parameters.Add("@b",TextBox2.text)

now in ur select code instead of using ? mark use @a and @b.
where @a,@b r placeholders