ComboBox Function

[Mats]

I am trying to create a ComboBox Function that retreives a recordset based on SQL. I know how to retreive the recordset and I've got the ComboBox Function from the MSDN-pages. My function doesn't however allow me to set the ComboBox to Null (this can be done with a normal combobox). The reason I'm trying to do this is because I want the ComboBox to retreive certain default rows if the recordset is empty. Has anyone got a working function of this type that I could copy?<br><br>Regards,<br>Mats

 

[DougP]

Well would an Empty String work &quot;&quot;<br>Or maybe a &quot; &quot; blank space<br>Then look for that or do something with either of them.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Mats]

Thanks for the suggestion, but as so many other times I found some bugs in my code... Now its working better. I've still got a problem: I get my records from a openrecordset command with SQL that I store in a static array. The SQL uses a listbox entry in the same form as parameter. It seems that sometimes my combo gets initialized before there is a selection in the listbox and this causes an error in the SQL. How should I write the SQL so that it doesn't crash if there is no selection.<br><br>Hope you understand what I'm after...<br><br>Mats