Unanswered: Info from Subform to main form
I have a query regarding data from a sub-form being transfered to a main form. At present i have a part list and a subform which holds prices from different suppliers. The cheapest price shown will automatcally be selected as the best price and will be shown on the main form. This part is easy.
The part i am having problems with is, the row with the best price has also a lead week (see attachment) field and this must be copied onto the main form. However i do not know how to do this.
I will be very greatful for any help
please check attachment