Add a ListView control as an alternative to the ListBox.
Add a ListView control like the one in Dynamics AX. The control should NOT HAVE master/child field linking. Only needs an after-update event that triggers when the user clicks on a row, just like a ListBox.
Access ListBox is frequently used for form navigation. It’s easy to implement but has several serious drawbacks.
Its worst drawback is the form blinking that occurs when the AfterUpdate event is triggered. This makes your form functionality unprofessional.
Other drawbacks: It’s static, user can’t adjust column width or row height. Can’t be filtered or copied from.
The current work around is to use a datasheet subform that calls back to the parent form on its OnCurrent event. This is tedious programming, problematic and may not work at all if the parent datasource and subForm datasource have inherited back-end relationships.