Maybe a bit improper but, "Did you try to find or create something like a search?" People here try to help, not do your work. You will not learn anything if you don't try to invent stuff yourself. Google or Bing is your biggest friend and off course forums like this one.
Fastest way is to use a combobox with your field as source.
A situation that I use quit often is: a subform showing a table, typing in a textbox rolls-up my table with the result. It works with a sql query.