Listbox Question

[avagodro]

I have a listbox, set to Simple Multi-Select. I have the code behind it that successfully saves the selected items to a table.
However, when I go back to the record in question it is not displaying the selected options in the listbox.
I have done a search but came up with nothing on this. Thoughts? Suggestions?

 

[BuilderSpec]

When you go back to the record in question do you then read the data from the record and put it into the listbox?

Do you save the data in the the listbox native form ? Each column entry separated by semi-colon ?

BuilderSpec

 

[avagodro]

Right now I am using:
SELECT tblResponsesList.Rspns, tblResponsesList.QstnID FROM tblResponsesList WHERE (((tblResponsesList.QstnID)=Form!QstnID));

This is the table which lists the choices available for each specific question, which is linked via QstnID. The results of the selections from the listbox are saved in tblResponses.

 

[BuilderSpec]

Why not have 2 list boxes..one is bound as the one above that lists all available questions etc. And the other is unbound , this is populated by a field on the table containing all the questions they have chosen, the table is updated after each form_current event and the field is updated whenver the unbound list is updated.



Hope this helps!

Regards

BuilderSpec