I have an application that that uses an Access database BE, with a VB.NET FE. I have a combo box that allows users to select a specific mailing list that relates to another table that contains the mailng list member data.
Some mailing lists contain upward of 50,000 records. So when the user selects a mailing list from the combo dropdown, the list control will populate with the members of the mailing list.
With mailing lists that contain so many records it becomes very time-consuming to add that many items to the ListBox view.
What would be the best / most efficient way to address this problem? Perhaps a list / grid control that populates only a few records, then if the user scrolls, will dynamically add more records to the control? I hope that makes sense. I using vb.net 2005, but I also have 2010 version as well. Any advise would be appreciated.