General information
Category:
Forms & Form designer
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only