Look Up Values returns a list of all values for the specified field from the database table, so you can select the value that you want. After selecting a value, click OK.
A subset of records that match your query criterion are displayed in the Data View window. To return to the Query Editor to refine your query, click the Return to Query button.