Filter a drop down list

[Jacques]

I'm trying to get a drop down list to filter itself based on what was chosen
in the previous field (drop down list). I've seen another reference in this
thread that had a lot of code to make it happen. I'm wondering is there a
way to achieve this without having to write a bunch of code.

TableA 1-many TableB 1-many TableC

The first three fields of TableD are the PK's of A, B, and C.

I would like to have a form that has a drop down for A, then a filtered one
for B based upon what was chosen for A, and the same for C based on B.

What's the best way to do this?

Thanks beforehand.

 

[Douglas J Steele]

Depends on how you're doing it.

If the ControlSource of each combo box points to the previous one, all you
need to do is issue a Requery in the AfterUpdate of the previous combo box.

Alternatively, you might actually set the ControlSource of the next combo
box in the AfterUpdate event of the previous one.

Check http://office.microsoft.com/en-us/assistance/HA011730581033.aspx

 

[Guest]

You'll need to write code, but not "a lot of code".

1.) In the AfterUpdate event of comboA, build a SQL statement and set it as
the .RowSource property for comboB.

2.) Requery comboB.

Assuming the PK is the bound column in comboA...
- ComboB.Rowsource = "select x,y,z from abc where PK = " & comboA.value
- comboB.Requery

If PK is not the bound field . .. where "w" is the column number with the PK
- ComboB.Rowsource = "select x,y,z from abc where PK = " & comboA.column(w)
- comboB.Requery


Hope this helps.

 

[Guest]

ooops... I think I meant to say "ControlSource" not "RowSource"