Use this method to complete a find operation and perform the actual search of the dataset for a row that matches the column values assigned to the various columns after the InitFind method was called. This method will return True if a row is found with the specified column values, or False if not. Specify True for the NearestMatch parameter to cause the search to return the closest match to the desired row, if the desired row cannot be found. Specify True for the CaseInsensitive parameter to cause the search to be executed in a case-insensitive manner for any string columns.
The NearestMatch parameter can only be set to True if there is an active sort on the dataset, as specified by the Sorted property, and the column values that were modified after the InitFind method was called match the columns in the active sort. Also, the CaseInsensitive parameter must also match the SortCaseInsensitive property if there is an active sort on the dataset.