>what is the syntax for a find operation eric

Don't you have MSDN installed? Here is what MSDN says:

Syntax

Find (criteria, SkipRows, searchDirection, start)

Parameters

criteria A String containing a statement that specifies the column name, comparison operator, and value to use in the search.

SkipRows Optional. A Long value, whose default value is zero, that specifies the row offset from the current row or start bookmark to begin the search. By default, the search will start on the current row.

searchDirection Optional. A SearchDirectionEnum value that specifies whether the search should begin on the current row or the next available row in the direction of the search. An unsuccessful search stops at the end of the recordset if the value is adSearchForward. An unsuccessful search stops at the start of the recordset if the value is adSearchBackward.

start Optional. A Variant bookmark that functions as the starting position for the search.

And MSDN continues with other stuff and even an exemple.