this is more of a DAO and not very good but easiest code is using a query as @Jamo stated so tell us your ADO is it code based or you are using the ADO control<br>never forget to say THANK YOU<br><br>Private Sub cmdFind_Click()<br>

&#39;Note: Bookmark only works correctly<br>
&#39;with Client-side cursors<br>
Dim dBookmark As Double<br>
dBookmark = rsEmployees.Bookmark<br>
Dim sFindCriterion As String<br>
sFindCriterion = &quot;LastName like &#39;&quot; &amp; _<br>
txtLastNameToFind &amp; &quot;*&#39;&quot;<br>
rsEmployees.MoveFirst<br>
rsEmployees.Find sFindCriterion, , adSearchForward<br>
If rsEmployees.EOF Then<br>
rsEmployees.Bookmark = dBookmark<br>
MsgBox &quot;Couldn&#39;t Find &quot;&quot;&quot; &amp; txtLastNameToFind &amp; &quot;&quot;&quot;*&quot;<br>
Else<br>
txtLastNameToFind = &quot;&quot;<br>
End If<br>
End Sub<br><br><br><br><div class="gmail_quote">On Mon, Oct 31, 2011 at 8:02 PM, jamo njoroge <span dir="ltr">&lt;<a href="mailto:patjayke@gmail.com">patjayke@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
a search boils down to the query you issue, paste to code from the button and maybe i can help<br><br><div class="gmail_quote"><div class="im">On Mon, Oct 31, 2011 at 4:55 PM, dennis munyotu <span dir="ltr">&lt;<a href="mailto:dmunyotu@gmail.com" target="_blank">dmunyotu@gmail.com</a>&gt;</span> wrote:<br>

</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">Hi skunkers i am looking for a search command button  in vb 6 using ADO but all in vain...<br>
<br></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>MICHAEL A. AKUNGA<br>(+254) 0726 174 815<br><a href="mailto:michaelakunga@gmail.com">michaelakunga@gmail.com</a><br>
<a href="mailto:michaelakunga@yahoo.com">michaelakunga@yahoo.com</a><br>