layout for CRUD in table with many columns

[LaVolpe]

Can you use a listview to CRUD individual records? The field values would be in the first listview column and the field names in the second column -- then change the order so the field names are first. This allows user to enter directly into the field values column.

ListView1.ColumnHeaders(1).Position = 2

Then you can load an individual record using code similar to the following. In this example, we'll assume your records are in a recordset RS:

    Dim n As Long
    ListView1.ListItems.Clear
    For n = 0 To rs.Fields.Count - 1
        With ListView1.ListItems.Add(, , rs.Fields(n).Value)
            .SubItems(1) = rs.Fields(n).Name
        End With
    Next