I need to create a Recordset (NO DATABASE) - Stand Alone to move though records and delete records from an Array of values.
arrTest(0) = "A"
arrTest(1) = "B"
arrTest(2) = "C"
I want to move these values from the Array to a Recordset.
I need to loop though the Recordset and where ever I find a matching letter I need to delete it when I find a matching letter. Once I've looped through all the records I need to write it out to a file. The problem I was having with the Array was that if I delete an item in the middle of the Array I would have to re-number the array to loop though it later to write out the file.