Help_The row sources of Combo Boxes in a form are dependent, How W

I am working on a MS Access Form, there are 2 combo box. The row source of
first combo box are from a list in a table, the row source of second combo
box are from same table, a select query that the records are only belong to
conbo box 1.

The probelm is:
The list of second combo box are working only once. If I change the value of
combo box1, than the list of second combo box will not work any more.

Who can help me? Thank you very much!


Leo

Without seeing the recordsource for the two combo boxes and the code in the
afterupdate event, I would guess that you are not requiring combo box 2 from
combo box 1.


In the afterupdate event code, you should have something like