<div>
REcordset.Find(&quot;Field = '&quot; &amp;&nbsp;combo1.text &amp;&nbsp;&quot;'&quot;) <br />

</div>


REcordset.Find("Field = '" & combo1.text & "'")


<div>
Excuse me for rejecting the answer. I use the DataEnvironment and I cannot do a search like I want.<br />
<br />
I uses this command<br />
Ex.: DataEnvironment1.rsPRODUCT<wbr />.Find (&quot;ProdNo=2&quot;) //normally the number come from a combo box<br />
DataEnvironment1.rsPRODUCT<wbr />.Requery<br />
<br />
I think it doesn't work because the other control bound to this datasource are not updated!<br />

</div>


Excuse me for rejecting the answer. I use the DataEnvironment and I cannot do a search like I want.

I uses this command
Ex.: DataEnvironment1.rsPRODUCT.Find ("ProdNo=2") //normally the number come from a combo box
DataEnvironment1.rsPRODUCT.Requery

I think it doesn't work because the other control bound to this datasource are not updated!


<div>
<div class="content wysiwyg-content">
I have a products table, wath I want to do is simple. Have a combo box contaning all to products name. When I choose a products in combo box. The recordset jump to this record.<br />
I find it difficult to navigate with the ADO recordset becuase there is no seek method and I don't understand the find method! How can I go to a specific record?
</div>
</div>


I have a products table, wath I want to do is simple. Have a combo box contaning all to products name. When I choose a products in combo box. The recordset jump to this record.
I find it difficult to navigate with the ADO recordset becuase there is no seek method and I don't understand the find method! How can I go to a specific record?

New ADODC objects?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.