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.

Help please.

Juan B. García