The issue being I have two forms, one being the item form and another the order form. In the order form there is a sub form where there's a lookup to the item form using one of its fields but what Im having issues doing is using the lookup function in the subform and auto filling a field with data from the item form... 

Ive tried so many ways and I'm trying to keep it as simple as possible for the users... The best way we have thought of is using a sub form to add items to the order using lookup functions but we can't get it to fetch data in the subform. Any recommendations of a solution or another way of accomplishing this would be a great help!