Help Needed With Dropdown Lists

  • Thread starter Thread starter Jason Wills
  • Start date Start date
J

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
 
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'
Click to expand...

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
 
Back
Top