RE: What is differnce between find & filter when using...
Find method is basically use to search(find) the record from the recordset while Filter record ask the user which record the user expect and as per the condition in filter it return you the result.
RE: What is differnce between find & filter when using...
Find will move the recordset to the matched location and filter will filter the recordset so that only matched records will be available in the recordset. Only when you reset the filter to nothing the original recordset is gained again.