![]() ‘ If a partial value is typed, filter for a partial company name match. ‘ Use the ListIndex property to check if the value is an item in the list. ‘ If a combo box item is selected, filter for an exact match. ‘ If the combo box is cleared, clear the form filter. ![]() Then in the Change event of the Combo Box, we add the following code: ![]() To do this, we add a Combo Box named cboFilter, with the following notable properties: We want to allow users to filter this list to easily find a customer, even without knowing the full customer name. The “Customer List” form is a Split form that displays a list of all customers. This example uses a slightly modified version of the Northwind 2007 Template, available for download from Microsoft. As the user types, the form filter updates to display full or partial matches for the value entered. Here’s a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box. ![]() , a leading Access applications company, which designs custom solutions to improve operations for small and large organizations in all sectors.) (Guest blogger, Molly Pell is a Senior Systems Analyst at FMS, Inc.
0 Comments
Leave a Reply. |