I would like to know how to search a database (.dbf file - table name = docket) for a certain record (fieldname = casenumber) with VB6 learning edition. I have a form set up with a datacontrol (data1) connected to this table and have text boxes connected to the following field names:

Casenumber
Memo
Last name
First name
Code

When I do a search by either another text box or input box, I would like to call up that particular record and populate all of the other form text boxes that correspond with that particular record. I am at the very beginning of the learning curve of VB and I have tried to make this work with other examples I’ve seen; but have not been successful. Any help would be appreciated.

Also I would like to know how to when using a grid, I could make text boxes get populated when a user would highlight a recordset.

Thanks