I have a combo box on a form who's Row Source is driven from a simple select ( Select SalesSource, CurrentState from tblSource Where CurrentState = "Live"). The LimitToList property is set to Yes. The user can only select one of the valid entries from the list. If they try to type something else the "Not in List" event triggers to show them that they must choose something from the valid list. OK so far - Access is working fine.
However, if the user wants to use Filter by Form from the ribbon / menu and types "Broker*" to see all records from all brokers the "Not in List" event fires because "Broker*" is not a valid Sales Source.
How can I get LimitToList and Filter by Form working in harmony? Do I have to emulate the "Not in List" functionality in VBA rather than letting Access do it?
Any thoughts welcomed.
Ray
However, if the user wants to use Filter by Form from the ribbon / menu and types "Broker*" to see all records from all brokers the "Not in List" event fires because "Broker*" is not a valid Sales Source.
How can I get LimitToList and Filter by Form working in harmony? Do I have to emulate the "Not in List" functionality in VBA rather than letting Access do it?
Any thoughts welcomed.
Ray
