Limiting the contents of one list based on another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have created two combo boxes that limits the contents of a combo box based
on the selection in another combo box. These combo boxes are in the Form
header and are unbound. The information is then displayed in the detail
section of the form. When I open the form and select from the combo boxes,
the information is displayed correctly. If I go back to the combo box and
make another selection, the information in the detail section remains on the
first selection that was entered. I have to close the form and reopen to be
able to select and display new information. How can I do this without having
to close the form each time I want to make another selection?
 
In the first combobox add this code in its after update event:

me.secondcombobox.requery
 
The second combo box is requerying correctly. When I reselect from combo box
1 and then make a selection in combo box 2 (based off of combo box 1), I am
having difficulty displaying the new selections information in the detail
section of the form. The original selection still displays.
 
Thanks for the info. I added the code, but my form's detail section is still
not updating to the new selection made from the combo boxes.
 
Back
Top