Thank you very much. It is what we need. I don't do too much with arrays. I see that you changed the ColumnCount = 2, which I haven't thought of that, and I also changed the Font = Courier... Anyway, I like to ask how you add a New Property of
lasql[2,0]? I did see the Form INIT, but that does not effect the Form Property?
About the
Go To button, that is after selecting the record in the listbox, then
Go To that record and bring up another form with more details. I was asking if the array would still be able to refer to the right record of the live/real table so I can retrieve the data. I will see if I can do it with this array.
Thanks again for looking at it.
Chuck
>I took a brief look into the form (didn't have time to work on it in details). I think, the main prioblem was that you have to select into thisform.laSQL and RowSource for ListBox should be
thisform.laSQL, not just laSQL, because otherwise it just goes out of scope, that's why you didn't see anything in your listbox. Basically, it was the only change I made (with few small others).
Today is tomorrow's yesterday.