The "=[ComboBoxName].Column(1)" method works fine, thank you for your help.

This Price is actually list price, so it's a field in Products table. I just
want it to be displayed here as reference. Sale_Price is a bound control to
write into Order table that need to be entered in the Orders form.

Guangew

BruceM wrote:
The combo box displays only the bound column after the selection, although
the drop-down list can display several columns. Use text boxes to display
other columns. In the Control Source of a text box, something like:

=[ComboBoxName].Column(1)

Column numbering is zero-based, so Column(1) is actually the second column.

BTW, price is often a value that needs to be stored so that it shows the
price at the time of the transaction, which is not necessarily the current
price. In that case you can use the After Update event to the combo box:

Me.SalePrice = Me.ComboBoxName.Column(2)

SalePrice is a field name.

In my database, I have Products table and Orders_Details table that contains
Product_ID field and they have one to many relationship.
[quoted text clipped - 13 lines]

Guangdew

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1