Refreshing the listbox
hi i am new in access and vba and working on audit database now. i have a llist box which is multiple select and is populated with some standards. user then selects from these standards and allocates the selected standards to the audit. user is also provided to add the new standards as well. until here it works fine. but the problem is that if user selects some standards bofore adding new standard then after the list refreshes the new standard may replace the selected standard depending the sort order. for example
if national standard was at the third row in the list and user selected it then he added local standard, then after list refreshed the new standard i.e local is selected instead of national standard. i want to keep the selected standards in list even it updates and refreshes. hope there must be a way.
thanks for your help