Why a can not use the .list statement..

User avatar
sal21
PlatinumLounger
Posts: 4362
Joined: 26 Apr 2010, 17:36

Why a can not use the .list statement..

Post by sal21 »

part of code

Code: Select all

...
strDBRows = RST0.GetRows
  RST0.Close

  Me.ORDINE.Clear
  Me.ORDINE.AddItem "TUTTI"
  
  'Me.ORDINE.List = strDBRows(1, I) & " - " & strDBRows(0, I)
  
  For I = 0 To UBound(strDBRows, 2)
    Me.ORDINE.AddItem Format(strDBRows(1, I), "#0000") & " - " & strDBRows(0, I)
    CONTA = CONTA + 1
  Next I
..
why instaed to loop with for next i cannot use the .list statement to fill the combobox.ORDINE in "one shot only"

Based this old post: http://www.eileenslounge.com/viewtopic.php?f=30&t=4429" onclick="window.open(this.href);return false;

Note:
i just have ordered the value via sql query not important to use the Ordering loop.

User avatar
HansV
Administrator
Posts: 78537
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Why a can not use the .list statement..

Post by HansV »

Also asked in Post=59023. This thread is locked to prevent further duplication.
Best wishes,
Hans