Unanswered: field value from a table to another table in a subform
I have an "extended" query on which a subform is based. In this subform I enter the order details: item name which I obtain through a combo list that I obtained with the look up wizard when I designed the order details table. The item name is obtained from the products table.
However, I also want to obtain the price from the products table so that it is written in the order details table. I do not seem to be able to get it. I have tried changing the properties in the control of the subform so that the default value was the one indicated in the products table but it does not work.