Ok.
I have a form with a field for a sampler's name, number, and email address. The sampler's name is selected from a combo box that references a table with name, number, and email. I want to be able select the name in the combo box and have the fields for the phone number and email address fill with the selected sampler's info. I have tried setting the control source of another combo box (for the email address) to the samplers name combo box. This does show the email address, but when I try to use that for my email it comes in as the Sampler's Name (primary ID) instead of the address. HELP?