DoubleClick Combo Box to set to Null -
02-21-2011
, 05:55 PM
I'm using values selected in a combo box as part of a filter procedure.
To remove the filter I use Me!cmbCostTypes = Null in the double click event.
It has worked fine in Access 2002 and earlier, but in Access 2010, it will
only work if I remove the default value from the control's Properties
dialog. Otherwise, it will not set to null.
The default value is '=[cmbCostTypes].[ItemData](0)'.
I've rebuilt the combo with no joy, and removed all other events to test.
Once again, it seems that something has changed in Access 2010.... but what
is it and why?
--
Bob Darlington
Brisbane |