Please help me figure out why I can not access the data stored in my array. Below is a snipet of my code.


'Under General

Dim intAirportCodeArray(5) as long ' Variable array to store 5 records



This is how I store the data in the array and it is working because I am able to display it.

Public sub loaddata()

   ' read record....till eof

      intAirportCodeArray(intRecordIndex) = rsAirport!Airport_ID
       rsAirport.movenext
       Label80.Caption = intAirportCodeArray(intRecordIndex)


    ' loop to next record to store data to next variable array


end sub


This is when I am retrieving the array so I can update the database. I keep getting 0 in all intAirportCodeArray array.

public sub updatetables()

    intmaxidx = 0

 If Not intmaxidx = intDepartIndex Then 'intdepartindex was
           populated previously
    For intIndex = 0 To intDepartIndex
      rsFlight!From_Airport_ID = intAirportCodeArray(intmaxidx)
      intmaxidx = intmaxidx + 1
      rsFlight.Update

    Next intIndex
  End If

end sub


Please let me know what I am missing or doing wrong. Did I declare or create my array correctly?

Thanks

Your array is big enough to hold 6 records, not 5 . . .

I presume you say that the storage is working because displays the right data. Is that right?

I further presume that you believe your array is not working properly because when you examine the database after public sub updatetables() runs, and the data are not there. Is this correct?

If this is so, I would like to know what yields in the immediate window...

My answer to your first two questions are both yes. I pressume that I am able to store the data but not able to retrieve it because I might have something missing in my procedure to retrieve them. I also know that aside from these two procedures, storing and reading the data to and from the array, nothing in the program touches them or initializes them.

Your question, what yields in the immediate window? It's 1 and 17 since there were only 2 data stored in this array.

I did some debugging and I found where the array was getting dropped. My application is calling a procedure from another form. After it goes back to the current form, it is being dropped.

What I am doing is editing an existing travel record. I do this first when a user clicks the toolbar to edit it. I then call a form called frmTraveller to populate a listview item. Then, when the user selects which record to edit, he or she then calls a procedure called fillfields which is in a different form called frmTravel. This is where the array is getting populated and I can see that the array has records stored in it. As soon as the procedure fillfields is done and the focus is back to the frmTraveller, I use debug.print to display the contents once again. This time it's gone! Below is the code for the module modConnection, frmTraveller and frmTravel.


Thanks for your help.

Okay guys. Somebody was able to point out what I was doing wrong. I have my Arrays Declared both globally and on the form level. I have forgotten to take the one I declared on the form level when I put one globally.

Thanks for all your help