By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Repopulate Listbox with prior selections

P: n/a
Hi All,

In Access97 I have a form, to add a record, one of the controls is a
simple-listbox which users select multiple values from. When the user
clicks the 'Add Record' button on the form the vba code stores the list
of selected items from the simple-listbox in a field like:

Bread;Milk;Butter;Salt;etc.....

Users can update records via an Update form and so when a record is
displayed on this update form I want the previously selected items from
the simple-listbox to be selected(highlighted)in the listbox.

What is the vba code to do that?

thanks, in advance, for any help with this.
bobh.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.