Comments

: My problem is that i can't get it to pick up the value of ListBox2!! : even if it is just a single value it won't work and I have no idea : where to start in referencing multiple values with SQL.....: : I hope someone can help me as it's driving me nuts : : Many thanks!!!!: : Roxanne: : : there are two issues,

if the listbox Multiselect property is set to 0-fmmultiselectSINGLE then you can determine the selected value with (ONLY one item selected)-

if the listbox Multiselect property is set to 2-fmmultiselectEXTENDED then you need to iterate over the list items with [MULTIPLE items can be selected] -

Dim i As Integer For i = 0 To Me.ListBox2.ListCount - 1 MsgBox Me.ListBox2.Selected(i), , Me.ListBox2.List(i) Next

in the case of a multi-select, you could run a single sql statement for each case where- Selected(i) = True[that is, if list items 1, 2, 3 are selected, you need to do sql for each one those items) [performance-wise, you may want to batch the multiple sql's into a single transaction, and if one fails you can rollback the others]