I have a subform for orders (orderdate,itemid,itemname,unitprice). When I update the itemid the fields itemname and unitprice are upddated through DLookup from the StoreItems table. My problem is that this works on the subform. I have this subform on a main form called customer orders. It does not work on the subform when the subform is part of the main form. I other words if you open the subform and enter the itemid it does update those fields mentioned above. What am I doing wrong?

Please help. As this is the basis for me to continue setting up this database.