Need help with Combo Boxes

[jkincaid]

I need help on a simple database, I have limited ACCESS skills.
Here's my dilemma:

I have 2 tables:
Table one is customer issues
Table two is the particular customer

Table one includes: Issue id, customer, status of the issue (either unresolved or resolved), description, etc.
Table two includes: customer

I'm trying to put one combo box on my main form that allows one to select a customer so that a table will pop up giving information on just that customer's unresolved issues, and another that will allow me to select the customer's resolved issues and narrow it down to a pop up table that gives information on a particular customer's resolved issues.

What can I do?

I tried playing around with it, I know how to use the queries in order to make a button and have a button for each individual customer, but as a customer base grows how can I use a combo box so that all i have to do is update the main customer table when there is a new customer and it will add it to the combo box and when i have a new issue i just add it to the issue table?

Pleas Help... thanks

[Rabbit]

You can use the after update events of the combo box to open a query or a form based on a query, or a form that filters the records. How you want to do it is up to you and how you want it to look.