Can we put two or three sets of data into one combobox?
in [Tables]
|
Prev: Unexpected Delete
Next: Access 2007 Table Issue
From: guangdew via AccessMonster.com on 16 Feb 2010 11:08 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/Forums.aspx/access-tablesdbdesign/201002/1
From: guangdew via AccessMonster.com on 16 Feb 2010 15:53 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/Forums.aspx/access-tablesdbdesign/201002/1
From: guangdew via AccessMonster.com on 16 Feb 2010 19:24
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/Forums.aspx/access-tablesdbdesign/201002/1 |