Adodc filter function

[bluethunder]

Good day,

I'm having a problem with the filter function of adodc. I tried to filter records according to date range but I'm having an error message of "No value given for one or more required parameters"

This is the command text SQL of my adodc object

select * from pr_dtl where cut_off_date_frm = ? and cut_off_date_to = ?

[Rabbit]

When you use the question mark, you are designating that a parameter goes in its place. You did not define the values of your parameters.

[jamika]

try this

 If Adodc1.Recordset.RecordCount <> 0 Then
 Adodc1.Recordset.Filter = "yourfields Like '*" & Text1.Text & "*'"
 Else
 MsgBox "sorry no match found, try again!!", vbExclamation
 End If