Combobox filter on checkbox selection
I've got something really weird and I can't seem to figure out what to do about it.
My database is about Marine Research Institutes in Europe. You can imagine that an institute in Norway doesn't do research on the Black Sea, so I've added a number of checkboxes (Baltic Sea, North Sea, Black Sea, etc.) that store their Yes/No data in the main form. On this same main form I have an unbound combobox with a Value List that corresponds to the checkbox-values. This filters for records in which one of the checkboxes is checked. This all works! At least... when I set the Bound Column property to 0.
At the same time I have given the combobox a standard value "Select Water Basin here" when it is not selected. In the 'On Enter' event this standard value should disappear and a dropdown list is shown with the different Water Basins to select for my filter query. In the 'On Exit' event the "Select Water Basin here" value should return. This all works too! At least... when I set the Bound Column property to 1.
Now here comes the tricky part:
I want both things to work at the same time! When the 'Bound Column' property is set to 0, the filter function works, but the stand value/refresh function doesn't. And when the 'Bound Column' property is set to 1, it's exactly the other way around. I can't figure out what's causing this. I tried flipping the 'Bound Column' property in VBA, but I couldn't get this to work. There has to be another solution anyway!
I hope someone out there is able to help me on my quest! :-)