<div>
thats what i figured thanks<br />

</div>


<div>
<div class="content wysiwyg-content">
well i just need a little guidance here!<br />
I have a form with multiple datacombo box on it.<br />
depending if a user select an item from those combo I will do an sql query and find the information.<br />
Do i have to test each combo if the user selected something and then generate the sql. &nbsp;So it would look something like this<br />
if combo1 not null then<br />
sqlquery=select * where bla bla bla&amp;<br />
endif<br />
if combo2 not null then<br />
sqlquery=sqlquery &amp;&nbsp;bla2 bla2 bla2&amp;<br />
endif<br />
.<br />
.<br />
.<br />
<br />
<br />
or is there a way to generate the full sql and regardless if info is selected or not it would do it withouth all those test.<br />
Am new to vb programing am using Vb 6. <br />
any guidance would help
</div>
</div>


well i just need a little guidance here!
I have a form with multiple datacombo box on it.
depending if a user select an item from those combo I will do an sql query and find the information.
Do i have to test each combo if the user selected something and then generate the sql.  So it would look something like this
if combo1 not null then
sqlquery=select * where bla bla bla&
endif
if combo2 not null then
sqlquery=sqlquery & bla2 bla2 bla2&
endif
.
.
.


or is there a way to generate the full sql and regardless if info is selected or not it would do it withouth all those test.
Am new to vb programing am using Vb 6. 
any guidance would help

multiple combo and sql query???

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.