Fastest way to create a SQL statement is creating a query. But it is still not the answer you need.
Create a Form for your table with one of the form wizards then add a Combobox or Listbox to your form. You will have an option to create a combobox which finds records in your form. But make sure wizard option is on.