Computing.Net > Forums > Office Software > Access 2002 combo boxes

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access 2002 combo boxes

Reply to Message Icon

Name: RafaelArias
Date: March 19, 2003 at 13:30:44 Pacific
OS: Windows 2002 Pro
CPU/Ram: P3-866Mhz/128Mb
Comment:

I'm trying to design a table that has, among other fields, a field for define the kind of complaint my company receive from customers, and another field contains the root causes of these complaints. The root causes are more than 20, and they are especially associated with an especific kind of complaint, so I need that when I select a kind of complaint in a combo box, in the combo box related to the root causes appear only the root causes associated with the kind of complaint selected, to select one of them.



Sponsored Link
Ads by Google

Response Number 1
Name: smithdk
Date: March 19, 2003 at 15:58:33 Pacific
Reply:

Do you plan to have a separate table to show the association of these complaints and causes? On the form you could have 2 combo boxes. The first one the customers can input the type of complaint. The second combo box will show the root causes. You can restrict what is listed by what is chosen from the first combo box. On the row source for the second combo box, build a query so that it only shows the records based on what is selected from the first combo box. (example: field name of complaint = [forms]![form name]![combo1])


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Access 2002 combo boxes

Access 2000 combo box www.computing.net/answers/office/access-2000-combo-box/5260.html

Combo Box in Access www.computing.net/answers/office/combo-box-in-access/3477.html

Clearing combo boxes in access www.computing.net/answers/office/clearing-combo-boxes-in-access/5413.html