T
the_dude via AccessMonster.com
Dear all,
I have a form woth two combo boxes. Number 1 is for a family name, which is
looked up in a table. Number 2 is for members of the family. I want the
second combo box to only show the member names for the family in combo box 1,
not all member names possibe. Therefore, I have created a query and linked
that to combo box 2. When i run the form and look up the first family it
works fine. However, if i change my mind and want to look up another family
it still shows the previous results in combo box 2.
How do I get to update combo box 2 if i change the value in combo box 1?
Someone mentioned something about adding to the VBA to close the form and
then open it again but i am not sure how to do that or if that wouold solve
the problem.
I would appreciate any help.
the_dude
I have a form woth two combo boxes. Number 1 is for a family name, which is
looked up in a table. Number 2 is for members of the family. I want the
second combo box to only show the member names for the family in combo box 1,
not all member names possibe. Therefore, I have created a query and linked
that to combo box 2. When i run the form and look up the first family it
works fine. However, if i change my mind and want to look up another family
it still shows the previous results in combo box 2.
How do I get to update combo box 2 if i change the value in combo box 1?
Someone mentioned something about adding to the VBA to close the form and
then open it again but i am not sure how to do that or if that wouold solve
the problem.
I would appreciate any help.
the_dude