Hi guys,
I have a combo box that displays the results of a query. The results are always more than one record, which of course translates to multiple rows being displayed in the combo box.
I'd like to copy all records / rows from this combo box and insert them into a subform ( in datasheet view), with one record/row from the combo box corresponding to one record/row on the subform. I can copy the first and/or currently selected row of the combo box using simple VBA, such as:
However ...I'm struggling to find a way to copy and insert ALL the rows from the combo box into the form.
Any ideas would be very much appreciated.
I have a combo box that displays the results of a query. The results are always more than one record, which of course translates to multiple rows being displayed in the combo box.
I'd like to copy all records / rows from this combo box and insert them into a subform ( in datasheet view), with one record/row from the combo box corresponding to one record/row on the subform. I can copy the first and/or currently selected row of the combo box using simple VBA, such as:
Code:
Me!Form1.Form![Qty] = Me.[Combo1793].Column(0)
Me!Form1.Form![Type] = Me.[Combo1793].Column(1)
Me!Form1.Form![Name] = Me.[Combo1793].Column(2)
However ...I'm struggling to find a way to copy and insert ALL the rows from the combo box into the form.
Any ideas would be very much appreciated.