binding list/combo boxes

[rana]

Is there a way to make a combo box bound to another combo box in a form?

 

[WaltLukeIII]

You mean if something is put chosen in the first combo box then the second one automatically has a value entered into it?<br>If so then yes<br>in the form under the code you would have the program update the second combo box using the beforeUpdate Sub.<br><br>Walt III

 

[jimmythegeek]

You can do it in code, or the quickest way to do it, is:<br><br>In the Row source of the second combo box, click the elipse button, and add the fields you want.<br>Make sure you include the field that is represented by the first combo box (you don't have to show it, but include it).<br>In the criteria for that field put [Forms]![YourFormName]![ComboBox1Name]<br>Close and save the SQL Statement - Query Builder.<br><br>Now when you change the first combo box, the second combo box should be filtered by the criteria of the first.<br><br>Note: You can also build the SQL statements on the fly and assign the the Row source programmatically if you feel comfortable doing that, however it is more difficult.<br><br>HTH <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development