MS Access Filter Form Combo Box Too Slow to Populate
Posted on 2013-01-31
So I have 6 combo boxes in a form used to filter results into a subform. I have noticed that after the form first opens and I click one of the combo boxes, there is a noticeable delay before it actually populates all of the records.
I have read about using the OnChange event to filter out records based on typing in 3 or more characters (or whatever number of characters you want to set it too). But as nice as that is, this form would be used in a way by the users that they will actually click the drop-down arrow to see all the records and find one.
Is there a way to load up\prepopulate the combo boxes when the form first gets opened?