listbox.multiselect |
Dim zay As DAO.Recordset Set zay = CurrentDb.OpenRecordset("Zayavki", dbOpenDynaset) Dim varItem As Variant Dim i As Integer Dim lst As Access.ListBox Set lst = zayavki_ If lst.ItemsSelected.Count = 0 Then MsgBox "bla bla bla", vbOKOnly, " Error" Exit Sub End If For i = 0 To lst.ListCount - 1 If lst.Selected(i) Then zay.FindFirst "[code] =" & Me.zayavki_Column(0) zay.Edit zay.Fields("print") = True zay.Update End If Next i zay.Close Set zay = Nothing DoCmd.OpenReport "Otvet", acViewReport
http://www.sql.ru/forum/1260352/v-listbox-multiselect-otzyvaetsya-lish-posledniy-vybrannyy-element