ну теперь просто Find с параметрами
автор
Find Method


Searches a Recordset for the row that satisfies the specified criteria. Optionally, the direction of the search, starting row, and offset from the starting row may be specified. If the criteria is met, the current row position is set on the found record; otherwise, the position is set to the end (or start) of the Recordset.

Syntax

Find (Criteria, SkipRows, SearchDirection, Start)

Parameters

Criteria A String value that contains a statement specifying 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

TalenА почему не работает следующая конструкция и чем ее заменить?

а почему люди не летают - нету метода FindFirst