Requery Combo box with multiple select enabled

[CRobledo]

I have a cascading combo box with the option to select multiple items named (cmbBlock) it displays options depending on the combo box selection above it named (cmbVeriety). I would like it to requery every time cmbVariety changes. Below is the code I'm using.



Private Sub cmbVariety_AfterUpdate()
Me.CmbBlock = vbNullString
Me.CmbBlock.Requery
End Sub

But it seems that because the multiple value select with checkboxes is enabled it wont properly equerry. It displays the new options but also retains any check from the previous selection.

I have this in the afterupdate of cmbVariety. I'm not very good with VBA what do I have to add for the previous selected options to be unchecked.

[NTC]

I suggest you sanity check by making a stand alone query - that calls in the cmbVariety value as criteria. Select a Variety and then run that query to see that it returns the correct record set. This should give you insight to your design issue.

[CJ_London]

I think it is because you appear to be using a multivalue field - it actually stores the selections in a hidden table, so you will need some sort of code to delete all the records. I avoid using them because of their limitations so cannot suggest what that code would be but suspect somewhere down the line you will need to refer to the .value property of the field.

As NTC suggests, create a query and see what it looks like - if you have two selections (e.g. 24,26) you will get two rows of the table

[Missinglinq]

I think it is because you appear to be using a multivalue field

I'm sure that's it; MultiSelect is only a Property of Listboxes...not Comboboxes. The only Comboboxes with this type of capability are those displaying a Checkbox for each selection, as you mentioned...which means that the Field is a MultiValue Field, and they demand all kinds of special handling, not seen in other Datatypes...which is why most experienced developers eschew their use.

arnelgp gives some explanation/advice on this in this post:

https://access-programmers.co.uk/for...d.php?t=286000

Perhaps it will help.

Linq ;0)>