I need help,not very experienced with db,access 2003 & trying to create a subform with the following fields.Id,Date,Product Code(lookup query(fields are Product Code,Description,Last Purchase Price)based on "Products" table linked to another database),Qty,Last Purchase Price,Total.I would like the "Last Purchase Price" field to autopopulate once I have selected from the combo box a "Product Code" and then a total figure to be calculated automatically per line item.The main form contains job details,several subforms involved,e.g.inventory items used,non inventoried materials,labour.Multiple links to other databases exist,e.g.asset,inventory,tenders,work programming, should avoid double input. Is there a better way?Any help appreciated,& please idiot instructions reqd,I understand I need to do an AfterUpdate event but I don't seem to be able to manage it, I don't know whether it has anything to do with the data being from a linked table?