New Property, Filter for Combo Box
Scenario: Product Obsolete.
if product is marked as obsolete then we do not want it to appear on the combo drop down list but still must be visible to display historic data.
The Hack involves hiding a second drop down behind the first with a different rowsource, on click of the first we swap focus to the rear dropdown which then retrieves the required value without effecting the bound tables historical data.
Can you apply a filter to a combo box, on focus, for addition of records.
There are many times this would be handy. As in the example, removing "obsolete" products from the combo row source prevents then being added fine. However in a Datasheet the column now shows as blank for those products that are obsolete!
Yes this is often required!