I have a fairly complex application (to do with plants) that has two list boxes to select records in a table. One uses a field called 'species' and the other a field called 'com_name'. As well as this the order can be set to five different values (species, com_name, form, family,flr_col). All goes well till I change the index to something other than the default 'species'. After moving around in the table the list box looses some of the records, showing blank spaces. If you click in a blank space the name appears.
The list box is on a separate page of the pageframe but the result is the same if on the same page. I use the code
mid = listid
to refresh the list but this still does not work.
If the index is set to say 'family' it is set back to 'species' when the page containing the list box is selected, then back to 'family' after the selection is made.
Is there any other code that will keep the list box refreshed?
The first image shows when it goes bad and the second one is when I click on a blank area. Some of the items come back but not all.