Combo Box and List box

[drSp00tnik]

Hi everybody,
this is my first post and i need help.
I am trying to create a DB for my work. I want to have combo box, and when i select item from that combo box, the selected item would copy it self to list box just below it. I hope u understand me.

So i have a form. and on that form besides many other controls i have one combo box, which pulls data from one table, now when I select any item from that combo box i want that item to be copied to the list box below it, and saved.

please help

nn

 

[Kevin_S]

First - If your going to be saving this information then you need to create a new table with a many to one relationship with the primary table (one with the values for this list) and instead of a listbox use a subform... Adding multiple values to a single field is not normalized data structure and will cause problems in the end...

Second - if you do not care about what I said above and wish to follow on this path anyway use the objects AddItem property:

Me.YourListBoxName.AddItem()

in the afterupdate event of the combobox...

HTH,
Kev