Passing values of listbox to other form's combobox
in [Forms]
|
From: pm4698 via AccessMonster.com on 24 Mar 2010 07:18 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1
From: Arvin Meyer [MVP] on 24 Mar 2010 08:05 Instead of writing the records to a table, use a query to read the output of the listbox and fill the values in a combo. An example of what I'm referring to is at: http://accessmvp.com/Arvin/Combo.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "pm4698 via AccessMonster.com" <u58261(a)uwe> wrote in message news:a57be01a55b12(a)uwe... >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 > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1 >
|
Pages: 1 Prev: Error 3021 but records exist Next: Grid control only displays 1 record |