I'm not sure if you still need help. I'm not familiar with access, since I last used it way back in school several years ago. See this link here: http://office.microsoft.com/en-us/access/HA011730581033.aspx , this seems pretty imformative for what you are doing.
I tried it out for myself using Access 2002, and I included the price column in my combobox control query. Then afterwards, in the textbox control where the price is supposed to display, I edited the property of the textbox control's Control Source by adding in ddl_name.Column(2), where the ddl_name is the name I used for my combobox control, and Column(2) to indicate the second column in my combobox query, which is the price. The form changes the price based on the selected combobox, but I'm not sure if this is the optimal way to do what you wanted. :)
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
(no subject)
(no subject)
I'm not sure if you still need help. I'm not familiar with access, since I last used it way back in school several years ago. See this link here: http://office.microsoft.com/en-us/access/HA011730581033.aspx , this seems pretty imformative for what you are doing.
I tried it out for myself using Access 2002, and I included the price column in my combobox control query. Then afterwards, in the textbox control where the price is supposed to display, I edited the property of the textbox control's Control Source by adding in ddl_name.Column(2), where the ddl_name is the name I used for my combobox control, and Column(2) to indicate the second column in my combobox query, which is the price. The form changes the price based on the selected combobox, but I'm not sure if this is the optimal way to do what you wanted. :)