>I have a combo box with rowsourcetype= 5 (array),I requery the array in DropDown event,but the no of items in list is erratic,the list box length of the list sometime is too long and something too short,sometime is normal.Can I stricly control the list box length by the length of array (my array is 3-dimensional) ?
>
>Any comment is highly appreciated.
>
>Arnold
If the data is coming from a table, you could use the COUNT command to a variable such as COUNT TO mcount FOR (logical expression). mcount would contain the number of records that meet this criteria. From there you can then re-dimension your array followed by your SELECT statement into that array. Another way that I have used is to use the _TALLY which will give you the number of records as a result of a SELECT statement or the RECCOUNT() function. It just depends on how you are populating the array as to which function or command you use. I hope this helps. It's worked for me.