Search by Date -- VB.NET

[rex028]

 Private Sub GetPO()

        Dim fromdate As Date
        fromdate = cboPOsearchTD.Text + "/" + cboPOsearchTM.Text + "/" + cboPOsearchTY.Text
        

        objDS.Clear()
        objDS = objUser.Search_tblUser("Select * from tbl_PURCHASE where Order_Date = 'fromdate'")
      
        Try
            dgPOSearch.DataSource = objDS.Tables(0)
        Catch ex As Exception

        End Try

    End Sub

I've got a Format Error "Data Format mismatch "

How Come ??

The "Order_Date " is in Date/Time format in MS Access Database !!

Please Help ! i've been stuck in this error for few weeks !!!

[amtrac24]

I would try changing the data type in access to text. Ive had problems in the past similiar to your issue. When using vb as a front end its better to just validate everything in vb rather then the database side