General information
Category:
Coding, syntax & commands
Hi Michael,
Well, if you dimenion the array to (1,1), then indeed you will only see one item in the list. Remember that to 'refresh' the combobox you need to issue the requery method, rather than refresh.
Form.Activate seems an illogical place to define the size of your array. To me it seems better to put it in with the code that fills the array, wherever that is.
Hope this helps, if not, more info is needed I think.
René.
>I have a form with a combobox. I want to fill this combo from an array. In the form.activate I dimensioned the array ( dimension myarray[1,1] ). I have the rowsourcetype = 5 and rowsource = 'myarray'. I can only see one entry in the combo box. I think this is because of the dimension, however, the table that is used to create the array changes the number of records frequently. How can I make the combobox show all records from the array. Also, when I display the array it shows several hundred entries but they all have the same value. For example. ? myarray
> 1 001
> 2 001
> 3 001
> 4 001 etc.
>Any help would be appreciated.
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