Query with results in a value list from a combo box?

I am trying to write a query that shows a result that would have been chosen in a combo box that relates to a fixed combo box. Is that even possible? If so, any suggestions on how I go about it? Normally I would have expected this info in a table and then I would know how to do it.
.