Cascading Combo Boxes

  • Thread starter Thread starter John Floyd
  • Start date Start date
J

John Floyd

I have a form with two combo boxes. The first lists
a 'major area', the second lists a 'sub-area' of the
first. I have used a query to get this to work, but it
will only work the first time I select values in the combo
boxes. If I try to select a different 'major area' then
the 'sub-part' list does not update to reflect the
change. I have tried to use docmd.requery to update the
list, but haven't had any sucess. Can anyone suggest how
to get this to work?
Thank you in advance.
 
Assuming you are using the criteria in the preceding combo
to filter the content of the next. I have nested up to 9
so far this way. I get them to stay up to date by using
ReQueury for each combo, triggered by the AfterUpdate
event in each. This means every combo in the chain is
updated whenever any other combo in the chain is upated by
the user.
Regards.
 
Back
Top