score:0

Accepted answer

for dao, try with:

filter2 = "[nom] = '" & olookfullname & "'"
rs.findfirst filter2
if rs.nomatch then
    debug.print olookfullname & " is not found."
end if

for ado, try with:

filter2 = "[nom] = '" & olookfullname & "'"
rs.movefirst
rs.find filter2
if rs.eof then
    debug.print olookfullname & " is not found."
end if

Related Query

More Query from same tag