Drop Down, link to another dropdown

[davelliott]

Hello,

I am wanting to build a Form with 2 dropdowns. The 2 dropdowns do relate to each other (in principle). See below:

AAA 111
AAA 222
AAA 333
BBB 444
BBB 555
BBB 666
CCC 777
CCC 888


CCC 999

What I want this to do is, that when I click on "AAA", the next dropdown will only show "111", "222" or "333".

1st question: I'm not sure if I need 1 or 2 tables for this? I can do what ever is suggested
2nd question: I can make the combo boxes, but I don't know how to make them related, so that when selecting something from the first drop, only related info is avaiable in the 2nd dropdown. Please advise?

I've tried a few things, but no sucess.

I appreciate your help,
thanks
David

[StepUP]

You only need 1 table.

Have your 1st DD be based on a query that has the "Unique Values" set to 'Yes' (so you don't show duplicates) and have the 2nd DD be based on a query with a where clause, similar to:

WHERE [Field1]=[Forms]![MyForm]![Field1]

Put code in the After Update event of the first DD which says:

[Forms]![MyForm]![Field2].Requery

[davelliott]

Thank you. I appreciate your time looking at this. I have more questions...
"Have your 1st DD be based on a query that has the "Unique Values" set to 'Yes' (so you don't show duplicates)". Okay, do I need to build a separate query or do i goto the properties of the 1st DD to Row Source and use the builder button to build the query? I'm not sure how to set it to "Unique Values". Is this something I do in the query builder or the DD properties?
I think I understand everything else.

Again, thank you for your help.
Dave

[Simon and King]

try going to
http://office.microsoft.com/en-us/as...730581033.aspx