I have Googled and searched your forum for an answer but I can't seem to get the code to work. I am either looking at this wrong or making it difficult for myself.

I have 4 forms Drawings; Material; Purchase_order and Work_order

The Material form has been put as a sub-form in the Drawings form. There is a field in there called "size" which is a single line text I wish to "fetch".

In the Work_order form the users selects a Drawing number from a Look-up field which is linked to the Drawings form.

This raises an order for a specific Drawing number. Now the user needs to create a purchase order to buy the material.

In the form Purchase_order the user selects the Work order number from a Look-up field which is linked to the form Work_order. When they select the Work order I want to fill a field in Purchase_order called "size" with the size of the material which is stored in a field in the  Materials form via the Drawings.

There is another scenario within my app that I need to do something like this to, so if anyone could help me out with some code and a explanation of it I hope I can learn myself.

My app is open for employee access if it is easier for you.

I hope I have been clear enough - many thanks in advance

Ben