2007 Multi Value Check Box Lists

[Sidney]

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

 

[john reed]

Just found this on Microsoft's site... hope it helps


http://office.microsoft.com/en-us/access/HA100311171033.aspx


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng