Unanswered: Set value of field based on another field
I have a table QuotationTransactions with fields ProductID, SellingPrice1 and SellingPrice2. I have created 2 fields on a form (ProductName and SellingPrice)
I need to allow the user to chose the Product and the SellingPrice should be filled based criteria
I have done the following which is not working
The source of ProductName is select productid, productname, sellingprice1, sellingprice2 from tblproducts
i set the source of sellingprice to products.column(2)
Can Someone recomenned me a better way to do this as I have to enter quantity for the product and then compute the sum total
When you say
I hope you really mean
Also, I assume that ProductName is a combo box, and that SellingPrice is a text box.
Since this obviously represents an Order Detail form that's bound to an Order Detail table, why not just add the quantity field right there on the form, since it's going to be saved to the table as well. No need to save the total price to the detail table, save that info for the Main Order table. But I'm getting ahead of the game.
Yeah you are right I have been thinking in those terms too.
Product Quantity Unit SellingPrice Total
--- --- --- --- ---
So the user would use a drop down to select a product. Enter the Quantity and then Choose the unit for that product (eg: meter, boxes, rolls) Based on the unit chosen, total should be quanity*sellingprice1 or quantity*sellingprice2
And then Sum Total is sum of all totals.
When I use productname.column(2) , the prices show up at #Name# so I am unable to get Totals
Here is the attachment. I am trying to make a quotation software. Quotation Subform is actually a subform that I will use in a main Quotation form, which I will use to create a Quotation.
UnitPrice should be set to SellingPrice1 by default
But if The Unit is selected sqm or meter then UnitPrice should be set to SellingPrice2
Then I need to find the Total for each product and then the grand total for the quotation
Sorry, I can't see anything at all without the main form. All you sent me was a subform that has no controls on it. In order to allow me to help you, please re-upload the main form along with the subform.