Need help with drop down list 1

[ergonzalez]

I am creating a table with different information. This is the first time I've used access so I don't know if I'm using the correct terms.

I built two drop down boxes that depending on what I choose on the first box, something different will appear on the second box. For example: If I select "Cancel" on first box, the following will be my options for box 2: Password Issues
"Password Issues", "System Problem", "Srv Was Never Used". If I select "Billing" on first box, the following will be my options for box 2: "Misc Fee Inquiry", "Service Fee Inquiry".

What do I need to do for this to happen?

 

[MakeItSo]

This sounds like a query is needed:
1) I would suggest to create two tables:
One for your first choice, e.g. "Items" and one for the resulting second choices, e.g. "SubItems"

2) Let the Items table have two fields, e.g. "RecID" and "Choice".

3) Populate the table with RecID=1 belonging to "Cancel", RecID=2 for "Billing" a.s.o.

4) Now assign your SubItems table three fields, e.g. "RecNo" "SubID" and "SubChoice"

5) populate this table with the values "Password Issues", "System Problem", "Srv Was Never Used" a.s.o and assign all of them the SubID "1" as they all belong to "Cancel" a.s.o.

6) Choose "Items" as DataSource for your 1st dropdown

7) Build a query as datasource for your second dropdown saying: "SELECT * FROM SubItems WHERE [SubID]=[Forms]![(i)YourForm[/i]![YourDropDown]"

8) Add this to you dropdown's AfterUpdate() event:
DoCmd.Requery "Your second dropdown"

Let me know, if it worked.

Regards,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos