Saving 1 Listview Column Values

[abelingaw]

Was trying to save the contents of a listview column (2nd column) into a table in the dbase, 1 column of the table per content of the listview column, meaning only 1 row will be affected.

Here's my code using while loop.

Fcount = 2
Scount = 1

  While Scount <> Me.lvsub2.ListItems.Count And Fcount <> 11
      RS2.Fields(Fcount) = Me.lvsub2.ListItems(Me.lvsub2.ListItems.Count).SubItems(Fcount)

    Fcount = Fcount + 1
    Scount = Scount + 1

  Wend

Works but the problem is that, it only saves items from the 1st column of the listview and it gives an error ones there is a null value from the listview's column.
Any way to get around this with just a small modification of the code?

[Minimalist]

Maybe this link helps, struggle myself with the listview code:
http://social.msdn.microsoft.com/Forums/en-US/292ac5c0-a06b-4a77-be52-8ca3282e2edf/loop-through-listview-getting-items-and-sub-items?forum=vbgeneral

[abelingaw]

Sorry, but what I want is a shorter way so modifying my code would be great.