Create a main form with a subform.
In the main form, use an unbound text box, and say a "search" button.
The subform should have a query as it's record source that queries from your table. The criteria for [SSN] would be Forms![MainForm]![unboundTextBoxName]
Your search button should requery...