posted by ![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
quinn222 at 07:03am on 18/10/2008
quinn222 at 07:03am on 18/10/2008Can anyone on my flist assist with this question?
If I have four products:
a = $10
b = $20
c = $30
d = $40
I want to create two fields on the form, one a drop down box where the user enters the choice of a, b, c or d. I then want the corresponding field to automatically fill in the price. On the form and on the table of customers.
As far as I have been able to figure out I need my table of customers and then I need my table of products. I can make the drop down box where they choose the product but not make the price appear in the price box.
Help. Please.
If I have four products:
a = $10
b = $20
c = $30
d = $40
I want to create two fields on the form, one a drop down box where the user enters the choice of a, b, c or d. I then want the corresponding field to automatically fill in the price. On the form and on the table of customers.
As far as I have been able to figure out I need my table of customers and then I need my table of products. I can make the drop down box where they choose the product but not make the price appear in the price box.
Help. Please.
(no subject)
(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. :)