Combo Box (Second Column)

[BF]

Access only lets you bound the first column of a Combo Box to a table/query. Is there a way through programming to grab the second column and also bound it to a table/query?<br>
<br>
<p>BF<br><a href=mailto:g43@tc3net.com>g43@tc3net.com</a><br><a href= > </a><br>

 

[DougP]

Yes of course.<br>
In Design view of the form<br>
Double click the combo box to bring up properties<br>
click the &quot;Data&quot; Tab in the properties box<br>
Look for &quot;Bound Column&quot;. <br>
1 is the first column. Put any number you wish in there as long as you really have that number of columns.<br>
<br>
You can specify all sorts of things in the properties.<br>
Click the &quot;ALL&quot; tab and look down the list.<br>
<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[rochelle]

I'm not sure if you mean to bind the second column instead of the first or in addition to the first. I think Doug gave you the answer to the first interpretation. <br>
<br>
To bind the first column to one field and the second column to a different one, you can use the afterupdate event of your combo box. Just assign the value of your second column to another bound text box on your form within that procedure. I use this technique to update multiple values on a form with one selection. You're not limited to just two.