>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
Chuck,
In Go To you can put SEEK thisform.laSQL[1,1] (The table should be in a correct order) or you can use =SEEK(thisform.laSQL[1,1],"Org","OrgID") if this is an Org search. You can construct the same case statement using appropriate table and index. This should work, I think.
To add a new array property you just Click Form/New Property and type laSQL[2]. It will automatically create an array property. If you already created a property, which should be an array, you have to delete it, then re-add. At least, this is how I changed it to be an array.
BTW, did you see the recent UT announcement? :)
>
>>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).
If it's not broken, fix it until it is.
My Blog