Paired list boxes editing 1

[Delano29]

Hi, I am using Access 2003 and I have a database that I inherited that I need to correct a few things on. I have a paired list boxes on one of the forms. The two fields are unbound. I can add items to the database by selecting items from the left side of the list and moving them to right side of the lists using directional buttons and then selecting a save button that saves the selected information into a table. This seems to work fine. My problem is when I reload the form through a search query to view the record, the items I transferred to the right side of the list and saved no longer appears there. It’s saved because I go into the table and I see the items. I want to be able to call up the previously saved items in the table based on the control number of the record and have the option of modifying them through the same paired list boxes using directional buttons I use to add them.

I am kind of stumped on how to go about this or what sort of coding I would need. Please let me know if anyone has any suggestions.

Thanks.

 

[TheAceMan1]

How are ya Delano29 . . .

Since your talking multiselect here, you'll need and [blue]extra field in a table to store the selections (indexes)[/blue]. Gonna take a bit more code though as you need to pack the new field with a delimited concatenated string, and break it apart again to apply the selections . . .

See Ya! . . . . . .