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
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.
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])
Summary: I am working on a data access page in Access 2000. The table I am working off of has two fields that look up names in 2 other tables using combo boxes. When I create a data access page, and use the sa...
Summary: I have a combo box that is automatically filled with a list of client names when the form is opened. The only probem is, the text of the combo box (what you see before you drop it down) is always bla...
Summary: I have a number of combo boxes in an access form which help me search by various different fields. I want the other boxes to clear when i select from one of the boxes. Is this possible? many thanks MS...