Saving a Selection set
- Thread starter Thales750
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 20:11
- Joined
- Jan 12, 2001
- Messages
- 32,059
If using a normal list box, you can use code to iterate through the selections and save to a separate table. And to load it, in the form's On Current event you would do the reverse - to pull the values from the table and select them.
Or, if you are using Access 2007 or above, you can set the field in the table to be a Multi-Valued field and then you can bind that field to a combo or list box and have it do the work for you. If you use that method you would want to read about how to use them in this article:
http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx#BM7
Or, if you are using Access 2007 or above, you can set the field in the table to be a Multi-Valued field and then you can bind that field to a combo or list box and have it do the work for you. If you use that method you would want to read about how to use them in this article:
http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx#BM7
