Hi everyone, I need some help with an access 2010 form's subform.
In this subform there is a field called 'Product Name' that I want to be automatically filled in based on what is put in the 'Part Number' field. There is only one 'Part Number' for every 'Product Name'.
Currently when you enter the 'Product Name' the 'Part Number' for that product automatically appears. I would like it to do the same except vice versa.
Both 'Product Name' and 'Part Number' and combo boxes.
Thank you for taking the time to read this and I hope you can help!