Combobox Issues

[Lin]

Hello,

I have two combobox in a form. One is for Group(Ex:Construction, Mining
etc)and the other one is for Products. Using theFirst combo , I will choose
the group and then I would like to choose the products based on the first
combo. That is I would like to appear the products which is only belong to
"Construction" if I choose "Construction" on the first cOmbo. I use this
code Forms!FormName!Group in the Query criteria in order to do this. It is
working fine in the Query. but for the combo, it will work only the first
time when the form Loaded. When I change the Group throug the Combo, it still
displaying the first set.I wonder what I did wrong with the Combo? any help
really appreciated.
Thank you

 

[Jeff Boyce]

When you change the choice, you have to tell Access to requery the second
combobox. In the AfterUpdate event of the first combobox, use something
like:

Me!cboYourSecondComboBox.Requery

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lin]

Thank you Jeff. It worked.

When you change the choice, you have to tell Access to requery the second
combobox. In the AfterUpdate event of the first combobox, use something
like:

Me!cboYourSecondComboBox.Requery

Regards

Jeff Boyce
Microsoft Office/Access MVP