Help Needed With Dropdown Lists

[Jason Wills]

little problem with my own knowledge of access........

what i'm trying to do is to create a form that has a couple of drop down
lists.......(i'll try to explain myself)

(E.g.)

If i select '1' from dropdown list 'A' then i can select 'a,b or c' from
dropdown list 'B'

however

if i had selected '2' from dropdown list 'A' then i get a different set of
options in dropdown list 'B'

hope this is clear (not sure myself)

thanx for any help in advance

Jason

 

[Tim Ferguson]

If i select '1' from dropdown list 'A' then i can select 'a,b or c'
from dropdown list 'B'

however

if i had selected '2' from dropdown list 'A' then i get a different
set of options in dropdown list 'B'

Use the AfterUpdate event of the first combo box to call the .Requery
method of the second combo box. In complex cases, you may need to reset the
RowSource of the second combo box.

Hope that helps


Tim F