Form/subform

[Access_help_rob]

Form/subform Help please

Hi, i have a form which is linked to its a sub form via purchase order number now, on the main form there is a combo box which you can select purchase order number and a stock code on that order from the same drop down box, when you select the purchase order and stock code, it brings the number up in the subform so you can enter notes against the order and stock detail line, well thats wot should happen, however when i select a purchase order and stock code if that stock code is on another order as well as the one i want it will sometime bring that order in rather than the one i want, is there something i ned to do to my subform to correct this please help
thanks
rob

 

[dcx693]

You need to link the form and subform on the purchase order and stock order numbers.