Cascading combo/list boxes

[MarkP]

Hello, I have a combo box that feeds a list box1 which in turn feed another list box2. List box2 values need to remain in list box2 when list box1 has been change by the combo. The content of list box2 will be stored in a table. I guess this is 2 part question: Are there any examples out there on list box2 used as a collection point, and how hard would it be to store the contents of list box2 in a table? Thank you for your help.

[MarkP]

Correction: items selected in list2 would erase.

[RuralGuy]

Well the add would be a simple APPEND query in your loop that builds the ListValue string and the delete is simple a DELETE query with a Where clause.

[RuralGuy]

So a selection from the ComboBox gives List1 a new RowSource and clears List2, correct?

[RuralGuy]

You are still going to have a problem when you make a change in the ComboBox. The table does not really help you remember the selections in List1 unless you make the records unique to your cbo selection and add time. What would you expect to happen if the user make the same cbo selection again? Would you expect your previous selections to appear in List2?

[MarkP]

Yes you are correct about the combo box. If the user make the same cbo selection again then I would need a msg to advise of duplicate entries.

[RuralGuy]

Do you plan to just keep adding on to one table for all of the different selections?

[MarkP]

I was hoping to add the contents of the form to a table as a record for each event (daily there could be 10 to 20 records) entered and to use the selections in listbox2 as a string in a column in the table that would be used for reports.

[RuralGuy]

Would this table just keep getting bigger every day that goes by?

[MarkP]

Yes the table would increase daily and help in trending reports.

[RuralGuy]

Almost there. We need to know what the fields of this table will be and where the values will come from and probably a value from the ComboBox so we can set that value for the filter criteria on the List2 RowSource.