Experts:
I need some assistance with streamlining a form (i.e., listbox). Please find attached database which contains the following:
Objects:
a. Table "T01_Billets" -- contains 2001 records
b. Table "T11_WorkingGroups" -- contains 10 working groups
c. Junction table, 3 queries, 1 form
Current process:
1. User opens form "F01_Listboxes"
2. User selects any of the 10 working groups from combo (e.g., "Working Group A").
3. User selects values from left listbox "Available Billets" and adds one or multiple billets to "Assigned Billets" via the "right" (Add) button. This works great!
However, the challenge is that the billets table has 2000 records. Thus, if I want to add billet "2356 | Data Analyst I", I would have to scroll down half way in the listbox. Given that I sometimes need to add up to 20 billets/postions, the "scolling" and "finding" the billet can be quite cumbersome.
So, here's what I need some help with:
- While overall form process works well, I want to enhance the listbox so that I can start typing, e.g., "2356"... I then want any matching records to be on top of the listbox so that I can more easily add the billets.
- Is that doable? If so, what VBA needs to be added to achieve the filtering method?
Thanks,
EEH