.find

Hi!.. im using ".FIND" to search for a particular record.., what if there are 2 or more criterias to be searched.. i tried to use " and" but it didnt worked..

ex: adodc1.recordset.find " fld_name = '" + text1.text + "'" and " fld_course = ' " + text2.text + "'" ( "and" doesnt work here)

if .EOF then it saves blahblah...

thanks... :)