INSERT INTO with listbox

[TheShabz]

Hi all, question for you.



I have a form that contains 3 comboboxes and a listbox. Let's call the values of those ComboA, ComboB, ComboC and List{1-3}.
I want to turn the selection of those into a series of INSERT INTOs with List1 in the first, List2 in the second, and List3 in the third.

Any help?

[ajetrumpet]

so the 3 items in the listbox are the 3 inserts? is it one value per record? or is it one value per field, with one record total?

the best way is to loop the listbox values vertically, using listbox.columns(0, i), with i being the integer. concat values together with the rest of the sql string to get the final statement, then execute it with CURRENTDB.EXECUTE

[TheShabz]

the listbox is a multivalue listbox. lets say we want to assign students to a class. I have a combo box for a teacher, a combobox for a class, and a listbox of a bunch of students. The user selects a teacher, a class, and selects multiple students. each iteration of the students in the listbox would have to be its own insert into string.

[ajetrumpet]

the listbox is a multivalue listbox. lets say we want to assign students to a class. I have a combo box for a teacher, a combobox for a class, and a listbox of a bunch of students. The user selects a teacher, a class, and selects multiple students. each iteration of the students in the listbox would have to be its own insert into string.

so basically what you'd have in a situation like that is something like:

dim s as string
dim i as long

for i=0 to me.listbox.rows.count-1
   if me.listbox.columns(0,i).selected then
      //EXECUTE sql with "me.listbox.columns(0,i)" as concated value
   end if
next i

I'm not an expert with listboxes Shabz, so you'll have to get the properties on your own, but that's the idea.

[TheShabz]

I think that will work. My hangup was on the .selected. I'll let you know tomorrow if it worked out. Thanks!

[ajetrumpet]

I was close. see here: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

you need LISTCOUNT, not ROWS. sorry!

[TheShabz]

the syntax was a bit off but the logic worked. thanks!