Saving Listbox Selections

B

BBWTBB

I have on my database a listbox where you can make multi selections. How can
I make it so that when I close and then re-open the database the selections
are still in place?

I'm a complete beginner with Access so any help or advice would be greatly
received! :)

Many thanks
 
K

Klatuu

You question was vague, so I could not give a very specific answer.
Create a table with as many fields as there are columns in your list box.
In the close event of your form, delete the data un the table. Then use the
ItemsSelected collection of the list box to loop through all the items
selected and add new records to the table.
When you open the form, you will have to read through the records in the
table, match them with the rows in the list box and and set the selected
property to True.
 
Top