Hi,
I have two tables: Stock take Records and Cost of Materials. I have created a form based on the Stock Take Records table which has the below fields:
Part no
Item Description
Material Cost
Sub Con Cost
Labour Cost
(And others fields for stock taking)
(The Cost of Materials table also has the above fields).
I have changed the Part No to be a drop down selection that is looking at the Cost of Materials table. When I select a part number from this list, I would like the default values for the above to be populated with the values held in the cost of materials table. The numbers held in Material Cost, Sub Con Cost and Labour Cost need to be able to be changed for each record depending on how far along assembly is which is why I am trying to set them up as default values.
I have tried setting default values and using a DLookUp but can't seem to get it to work. Wasn't sure if i'm doing something wrong or do I need to do this by using VBA?
Any suggestions would be greatfully received!