By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,332 Members | 1,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,332 IT Pros & Developers. It's quick & easy.

Need help with Combo Boxes

P: 1
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
Jun 1 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,441
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.
Jun 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.