I need to be able to cycle through all of the fields in a database while cycling through the values in a listbox to see if records exist in the database with a certain field, "identifier", that maches the value of the listbox in that cycle...


understand?


This is what i have so far... but it doesn't even look as if it even got started... the records are still in the dbase...

VB Code:
  1. For i = 0 To lstImport.ListCount

  2.     For j = 1 To RS.RecordCount

  3.         If RS.Fields("identifier").Value = lstImport.List(i) Then

  4.             RS.Delete

  5.             RS.Update

  6.         End If

  7.         RS.MoveNext

  8.     Next j

  9. Next i

i know that the looping code is good, i believe my problem is in the location of the Delete, Update, and MoveNext commands...

thank you
squirrelly1