basic question, using the combo selection to run a query

[ErikZ]

Ok, So I have a form, with a combo box. I can get the query to pop up with a "After Update", but I don't know how to tell the query to search for the selection!

All the FAQs I've found seem to be a lot more advanced than this, "Sending the combo results to another combo" and the book I have seems to only have a full blown database as an example.

It's too early to feel this stupid.

 

[Edimator]

Be more specific, are you using the combo to perform a search on the form, or you use another field to perform a search on the combo box. Both have a simple solution.

 

[ErikZ]

A search on the form?

I have a table with "names" and "addresses". I have a combo box the names. When I select the name I want a query to run on the table and show me the name and address.

That was the example I came up with so I understand how to do it, in reality my problem is this:

In a table, I have a join table, a key column, a "people" column, a "job" column.

On the form I have two combo boxes, "People", and "Job". I want the user to be able to select the person and job, and have access look it up on the table, if it exists, the user will then delete it. If it doesn't, I'm going to figure out how to add a descriptive error message.