DougP - Thanx and 1 more question....

[lminmei]

the code works for only the Name field but not for the other fields (address, city, etc)<br>
in my combo box's row source, it is a query of the clients' names, and addresses (rows 2,3,4,5 and 6) <br>
I tried doing the same thing<br>
Me![Namefield] = [ComboBox].column(1)<br>
Me![Addressfield] = [ComboBox].column(2)<br>
Me![Statefield] = [ComboBox].column(3)<br>
...<br>
...<br>
<br>
but it didn't work.<br>
What did I leave out/do wrong?

 

[WP]

You forgot to increase the column count under Format of the combo box's properties.<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[DougP]

So the above code is in the combo boxes after update event right?<br>
In design view Double Click on one field that does NOT work on your form.<br>
Click the &quot;ALL&quot; tab <br>
Click in the &quot;control Source&quot; Property and make sure there is a field such as address in there and not the Word unbound. Then<br>
Make sure the &quot;Name&quot; Property is the same as the &quot;control Source&quot; Property i.e. address<br>
And try it again