I'm a bit confused with the whole array business.
I'm trying to gather all the recordID's in an array after a search result so a user can navigate through it using array functions.
Now, after all the other code - I'd like to read the recordID into the array like so:
Do While dr.Read()
' Add dr.Item("RecordID") to RecordIDArray()
How do I initialise an array I don't know the length of and how do I add values to it as this loop loops!?