Automatically fill in a field based on another field

[ZEEnon]

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!

[ajetrumpet]

http://www.access-programmers.co.uk/...d.php?t=155420

[hafaba]

On combo event : OnChange - write the code txtProductName = forms!subform!cboPartNumber ... if you give me details of your forms including the name of your combo, parent form and sub form, may be I can give the codes more precise .. Hope this will help you