M
magicdds-
I have 2 combo boxes on a continuous form.
After selecting one of 4 choices in combobox1 (from a value list), the
afterupdate property is activated to assign the rowsource property of
combobox2.
After selecting a choice from combobox2, both comboboxes display the choices
in record 1. (Both comboboxes are bound)
When you go to record 2, if the choice made in combobox1 is the same as for
record 1, the data displayed in record 1 remains unchanged. If in record 2, a
different choice is made in combobox1, the display in combobox2 for record 1
disappears (the reason is because the rowsource property of combobox2 has
changed). When you put the focus back on record 1, the oncurrent property
causes combobox2 of record 1 to show the correct data, but now the display on
combobox2 record 2 has now disappeared (again, because the rowsource property
of combobox2 was changed to the table for record 1.)
Is there a way to change the rowsource property of combobox2 in upcoming
records and still display the selected choices for the previous records?
Thanks for any help.
Mark
After selecting one of 4 choices in combobox1 (from a value list), the
afterupdate property is activated to assign the rowsource property of
combobox2.
After selecting a choice from combobox2, both comboboxes display the choices
in record 1. (Both comboboxes are bound)
When you go to record 2, if the choice made in combobox1 is the same as for
record 1, the data displayed in record 1 remains unchanged. If in record 2, a
different choice is made in combobox1, the display in combobox2 for record 1
disappears (the reason is because the rowsource property of combobox2 has
changed). When you put the focus back on record 1, the oncurrent property
causes combobox2 of record 1 to show the correct data, but now the display on
combobox2 record 2 has now disappeared (again, because the rowsource property
of combobox2 was changed to the table for record 1.)
Is there a way to change the rowsource property of combobox2 in upcoming
records and still display the selected choices for the previous records?
Thanks for any help.
Mark