hi im just starting to design a database using adodc but I have a problem...
can someone give me tip on how to create a search code for ADODC... thx in advance
Try the following code.
adcBrowser.Recordset.Find txtSearchHdr.Text & " like '" & txtSearch & "_'", , adSearchForward
'adcBrowser is the name of your ADODC
'txtSearchHdr.Text is your recordset field
'txtSearch is your search criteriaif you want to search for a hypothetic recordset field sname for "surname"
begining with "dav" then txtSearchHdr.Text is sname
and txtSearch is dav
adSearchForward or adSearchBackward can be used.