LeChat

hello all,

I am still in the process of learning VB6, but I made a little app allready. I have a access database with one table and quite a lot of records. Now i created a form in VB that shows all related fields in the database. i can scroll through, add delete etc. now i want to be able to search for data in the dbase. i created a cmd button that opens a search window...much like the one in IE for example. So i have a text box and a find button. from this form i want to search through the dbase and if a match is found goto to that specific record. closing the search form and all that is no problem, but i can't seem to find the appropriate commands to make this search happen.

any info is highly appreciated.

Regards

KnooKie

Based on whatever search criteria is entered you can execute a SQL SELECTstatement on the table to grab the correct record. It is then just a matter of opening a recordset on this SQL statement to display the searched for record.

Timbo

Or there's the ADO 'Seek' method of the Recordset object...

LeChat

Quote:

---

Originally Posted by Timbo
Or there's the ADO 'Seek' method of the Recordset object...

---

hmm i have been playing with this but can't seem to get the syntax in order, is it too much asked to give a small example on this?

thanks for the effort