Bound Column Question?

[dragonmanUSMC]

OK I hope I can properly explain this:
I have a form that has a subform that is viewed as a data sheet. The user will select a product from a drop down list on the subform, it will automatically input the base price as recorded in the inventory control, they will then input the quantity ordered, back ordered, and shipped, then the line total will be calculated.

Here is the meat and potatoes of the problem:
Sometimes there may be a discount given on the product. I have created a table that has a list of discounts the field names are as follows:
ID, Discount Name, Discount Description, Discount Percentage.

On my sub form mentioned above, I have added another column to show a drop down list of the discounts, if a discount applies the user will select the appropriate discount and then it will adjust the line total accordingly, however since the discount percentage is located in the 4th column of the table, I have told the control in the sub form to bound to the 4th column, when the disount is selected nothing happens, what am I doing wrong?Please Please Please Assist

Any help will be greatly appreciated.

 

[ZmrAbdulla]

You need to create a query instead of table that includes the column calculate the percentage..
It is easy to understand if you open the Northwind DB that shipped with Access

________________________________________________________________________
Zameer Abdulla
Visit Me
A sweater is usually put on a child when the parent feels chilly.

 

[Eupher]

How about showing us the code?

Ken S.