Hi
I've written some VBA code that reads the selections in a multi-select listbox and stores it into a table.
However, I'm facing a problem. The form is a multi-record form, and the user can go forwards or backwards in the form.
If he goes back, and he's already made a previous selection in the listbox which had already been stored in the tables, I want to restore his previous selections.
Also I need to know if he makes new selections so that I can delete those he deselected from the listbox from the table, and add new ones into the table.
I don't know how to do this efficiently. The best code example I found was this:
http://www.rogersaccesslibrary.com/forum/topic331.html
but it's too simplistic for what I need, because the table is very, very small. Mine can grow very large, and I don't have a boolean field that marks whether or not the item is selected. It's just stored into the table.
Does anyone have any sample code that can show me how to do this?
Thanks.