<div>
use vba codes to set the rowSource of the combo filtOff in the afterUpdate event of combo filtInst<br />
<br />
private sub filtInst_afterupdate()<br />
<br />
if me.filtInst &amp;&nbsp;&quot;&quot;=&quot;&quot; then<br />
&nbsp; &nbsp;me.filtOff.rowsource=&quot;sele<wbr />ct f1,f2 from tablex&quot;<br />
&nbsp; &nbsp;else<br />
&nbsp; me.filtOff.rowsource=&quot;sele<wbr />ct f1,f2 from tablex where f1=&quot; &amp;&nbsp;me.filtInst<br />
end if<br />
<br />
<br />
end sub
</div>


use vba codes to set the rowSource of the combo filtOff in the afterUpdate event of combo filtInst

private sub filtInst_afterupdate()

if me.filtInst & ""="" then
   me.filtOff.rowsource="select f1,f2 from tablex"
   else
  me.filtOff.rowsource="select f1,f2 from tablex where f1=" & me.filtInst
end if


end sub

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
2 comboBox : filtInst and filtOff<br />
<br />
ComboBox &quot;filtOff&quot; depend on the value of comboBox &quot;filtInst&quot;.<br />
To do it, i use &nbsp; &nbsp;Forms]![frm_Resen]![filtIn<wbr />st])<br />
<br />
If the comboBox &quot;filtInst&quot; is empty, I would like to see all value of &quot;filtOff&quot;.<br />
<br />
How this can be done?<br />
<br />
Thanks
</div>
</div>


Hi,

2 comboBox : filtInst and filtOff

ComboBox "filtOff" depend on the value of comboBox "filtInst".
To do it, i use    Forms]![frm_Resen]![filtInst])

If the comboBox "filtInst" is empty, I would like to see all value of "filtOff".

How this can be done?

Thanks

ComboBox base on an other one

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.