See attached simple database.
Customers place orders for car parts!
1. Run frmHeader which has a subform frmDetail.
2. Choose a customer from frmHeader
3. Now choose a part from frmDetail (Important: this is a continuous form)
4. So far so good!
Requirement: In the frmDetail - note the two yellow text boxes. How do I populate these yellow boxes with tblParts.Price and tblParts.Colour
(Obviously, the price & colour are for display only and not stored in the tblOrderDetail)