Having poured over my books, looked at web forums, had cups of tea - I'm stuck, can you give some guidance please?
I have a form with a combo box. The record source is a simple select from a table. The combo box property "Limit to List" = Yes and it works wonderfully. It limits the users to picking from the drop down list. If Filter by Form is chosen from the ribbon / menu and a value such as "Broker*" is placed in this combo box (to see all records that start with the word "Broker" rather than selecting a specific broker) the Not in List event fires before the filter is applied.
How can I tell the Filter by Form mechanism to ignore the Limit to List and just get on with displaying the records? Do I have to use the Before Update event on the combo box field to recognise things like *, ?, ! and emulate the Not in List functionality?
All thoughts welcomed. Thanks.
Ray
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar