I have a form with a list box that allows multiple (extended) selections. When processing the selections, I save the data to an intersection table (B) which relates the keys of tables A and C:
A --> B <-- C
Does anyone know how to retrieve the data for the list box when the form is loaded so that I can display the list based on the data that had been previously selected?
If I can't come up with a solution to this problem I think will implement a subform that shows the current selections and refresh the list after processing the listbox selections. Messy, but it should work.
A --> B <-- C
Does anyone know how to retrieve the data for the list box when the form is loaded so that I can display the list based on the data that had been previously selected?
If I can't come up with a solution to this problem I think will implement a subform that shows the current selections and refresh the list after processing the listbox selections. Messy, but it should work.
