Reply to thread

Message: [QUOTE="Sidney, post: 12723771"] I am using Access 2007 and trying to use the new multi value check box combo boxes. I have a subform with 2 combo boxes. The choices in the multi value combo box is filtered depending on the choice made in the first combo box. I am using VB with the On Change event in the first combo box so that the second multi value combo box requeries with the new filter. Here are my questions: 1. Everything works great when I set the subform to display as a single form. However, when I set the subform to display either as a continuous form (preference) or as a datasheet, the multi value combo box does not seem to work right. Whenever, I change the value in my first combo box (triggering the On Change event), the values in the multi value combo box in OTHER records now display the ID number versus the value. The current record I am in displays fine - it is just the other records displaying in the subform that seem to revert to the ID number. How can I keep it so that the values display even if I change the value in the first combo box. 2. For some reason, I cannot find a way to delete the values in the multi-value combox box if I change my value in the first combo box. Since the multi-value combo box filters on the first combo box, when I select a different value in the first combo box, it should delete the existing value in the multi value one and requery and return choices based on the filter. The requery and the display of the choices based on my selection in the first combo box works, but it also retains the prior value. Any ideas would be greatly appreciated. Thanks Sidney [/QUOTE]

Verification