My question is:
I have two combox: 1 & 2. I want the content of combox 2 depends on the selection of the contents in combox1. So far, i have put two queries in the rowsource for two combox. However, i found when i pick one item in combox 1, the contents in combox2 don't automatically updated although when you go back to check the queriy result, the query do bring back the correct result. I wonder if i should add an event or something to make automatic update happen. I would really appreciate your guidance.
Thanks
I have two combox: 1 & 2. I want the content of combox 2 depends on the selection of the contents in combox1. So far, i have put two queries in the rowsource for two combox. However, i found when i pick one item in combox 1, the contents in combox2 don't automatically updated although when you go back to check the queriy result, the query do bring back the correct result. I wonder if i should add an event or something to make automatic update happen. I would really appreciate your guidance.
Thanks