Hello,
It appears this form in not used to scroll through records so this should be fairly easy. My preference is to use the When losing focus
event but that is ultimately your choice.
When you enter your macro you check if the record exists already (most likely with an SQL statement to see if record returned based upon # entered). If not already existing just exit the sub.
If record does exist, you can Filter
the table and reload it:
sFilter = "(""Phone#"" = '" & phone_number_from_form & "')"
oForm.Filter = sFilter
oForm.Reload()
oForm.Filter = ""
With phone_number_from_form
this is the field you already have & used for the SQL.
The result will be only one record with the cursor in the next field if Tab was used. Because the filter was cleared in the last statement of the macro, a New record can then be selected & the process started once again.