Passing listbox's values to other form's combobox

[pm4698]

I have a form(frm2), in which i use a listbox(list1). The listbox is blank and it takes values from ather text boxes and comboboxes through vba code.

All i want, is when i push a button, to move the listbox values to a blank table tbl1.
In another form (frm2), i am going to use a combobox, which must have as rowsource the tbl1 content.
So, i want when the user fills in the listbox (through comboboxes and textboxes), the values of the listbox to pass as a rowsource to another form's combobox.

How could i do this?

Thanks in advance

[NTC]

well - it sounds like you are populating that list box via a text string entirely within the form & listbox control

fundamentally to fill in data to a table; make an AppendQuery to that blank table tbl1 - and trigger it with the OnClick event of the command button....

but you may have some tricky text/field set up in the vb of that sql statement

what you are trying to do is a bit non-standard; it is more straight forward to add data to a table by having the form sourced on the table and simply adding a new record.