P
Penny
I am trying to calculate a field in a form. I have a table that has the fields
Product _ID
Product Name
Product Price
I have an unbound combo box which selects a produce name. I am then
creating a calculated field in my form which calculates the area multipiled
by the price of the carpet. My calculation =[Combo22]*[Area of Carpet
required] works but from [combo22] picks up the product_id and not the
product price. How can I tell my caluclation to pick up the 3rd field rather
than the 1st one?
Product _ID
Product Name
Product Price
I have an unbound combo box which selects a produce name. I am then
creating a calculated field in my form which calculates the area multipiled
by the price of the carpet. My calculation =[Combo22]*[Area of Carpet
required] works but from [combo22] picks up the product_id and not the
product price. How can I tell my caluclation to pick up the 3rd field rather
than the 1st one?