Dreamweaver
Well-known member
- Local time
- Today, 10:36
- Joined
- Nov 28, 2005
- Messages
- 2,466
Hi Got this working for a single item selected in a listbox but all I get is the same record moved one for each item selected in first listbox.
Code:
Dim VarNum As Variant
Dim Str As String
If lstDepartments.ItemsSelected.Count = 0 Then 'Make sure items have been selected
MsgBox "Please Select At Least One Entry To Move", vbCritical, "No Entrie's Selected"
Exit Sub
End If
For Each VarNum In lstDepartments.ItemsSelected 'Start a loop though the selected days
Str = Me![lstDepartments] & "," & Me![lstDepartments].Column(1) & "," & Me![lstDepartments].Column(2)
Me.lstAssigned.AddItem Item:=Str
Next 'Move to next item in selected list