Participant Contact Database: Help with Search and Editing Data Entries

Hello Everyone,

I am super new to the VBA and programming world (i.e. this is my first time ever putting together a project and I have ZERO background in it. I am a Counselor by trade, so be gentle). PLEASE HELP!! I have reached out to my the Computer Science program at my local university and NO ONE has even responded to me. I am in a time crunch now to get this set up, so our research lab can go paperless and enter the 21st century!

My task: to create a database that houses research participant information with a new entry form and the capacity to search and edit information that is already entered in the spreadsheet (any columns, any text, as we can't have duplicate entries and as participants come back for multiple studies, and/or their contact information changes). Note: It is an infant research lab and it is of utmost importance to search all possible matches because sometimes, although infrequently, an infant dies and we DO NOT want to be contacting those parents to participate in studies.

So far, I have created a form that populates new entries; however, I cannot figure out the search function and edit (with SAVE button) information that is found. The search isn't working and highlighting a certain contact in the spreadsheet does not populate the data in to the form.

PLEASE HELP!! I have been watching hours worth of Youtube videos, all coding this differently, and so far, none of them are working. I will attach my Excel Macro Book. There is no Real Data yet in the spreadsheet.

Additional Inquiry:
Sidenote: I would like the ID # spot to auto-populate with a new sequential # each time a New Entry is added. It was working for a hot second, then it stopped.

Thank you in Advance!!!!