combo box needs to copy related fields

[tcrank472]

Access v 2010; Win ver 7
I have a DB to track projects. On a form I created I have Project fields in a Masterform and a subform showing the Suppliers working on that Project.

I want to use a combo box to select the SupplierCompanyName and then also copy all of the related fields such as SupplierEmployeeFName, SupplierEmployeeLName, PhoneNumber.

I can get the combo box to select the SupplierCompanyName but not the related fields. Is there a way to do this without writing code? I can follow wizards or examples but don't have any programming skills.

Thanks in advance for any help!

 

[jackd]

Take a look at this free video tutorial

http://www.datapigtechnologies.com/flashfiles/combobox1.html

You said no code
but here are some samples

http://www.fontstuff.com/access/acctut10.htm