Cannot see material in form

[steve111]

I have attached a sample of my database there is a table called stocklist and one called order details

there is a part in both of these tables called GC3446M1

in the stocklist table it is under the heading of stocknumber
in the order details table it is umber the heading product no

I have created a form called order details of which I want to see the stocklist material when I select a part from the product no combo box

thanks
steve

 

[JHB]

The linked field in "Order Details" is a combobox.