Thanks for the response, but I don't think I understand the steps correctly. I keep getting an error that states "At most one record can be returned with this subquery"

HELP!!! I know this is something extremely easy and I am making it exceptionally hard...thanks again!!!

I don't know what you did in response to your last post. You should do the following.

Create an unbound form, Place a combobox control on it that uses the field which contains the value you want to query by. Set an event on the OnChange of the combobox to run the query.

In your query design, your criteria should read =[Forms]![UnboundFormName]![ComboBoxName]

There should be no other criteria under the field you are querying for according to what you asked for.

I hope that clears things up for you.