cmdADO.CommandText = "UPDATE Filmliste SET " & _
            "Filmname = '" & Text2(1).Text & "', " & _
            "Sprache = '" & Text3(1).Text & "', " & _
            "Genre = '" & Text8(1).Text & "', " & _
            "Format = '" & Text5(1).Text & "', " & _
            "Medium = '" & Text10(1).Text & "', " & _
            "Beschreibung = '" & Text7(1).Text & "', " & _
            "AnzahlCDs = '" & Text9(1).Text & "', " & _
            "Filmdauer = '" & Text11.Text & "', " & _
            "Originaltitel = '" & Text12.Text & "' " & _
            "WHERE Filmnummer = " & Text1(1).Text

_________________________
Professionelle Entwicklerkomponenten
www.tools4vb.de