empty fields in dropdownlist, help 1

[pomawo]

Hello,<br><br>I am dutch student that makes databases to pay for his study.<br>I have a question about a dropdownlist. <br>I am currently developping an sales-relation system in Foxpro. Everytime when an company is selected in a form, an sql selection searches the contactpersons from that firm an places the results in an array (arr_contact).<br>This works fine, when I look in the debugger screen for arr_contact it has the good values. The array always has the good values ! But now my problem : When I select an customer for example “ABLEF1”, that has 3 contactpersons those 3 will be showed in the dropdownlist correctly. But… when&nbsp;&nbsp;I select another customer “ABLOB3” with 1 contactperson, it shows then the person and two EMPTY fiels in the dropdownlist.<br>I want to get rid offf those empty fields but I don’t know how to manage that.<br><br>Thanks in advance for your help.<br><br><br>

 

[jonscott8]

Hi Pomawo,<br>&nbsp;after you do your query to the array, do a requery of the combobox.<br><br>Example:<br>thisform.[comboboxname].requery()<br><br>Jon

 

[AMakovoz]

Better yet, use NumberOfElements property!