I have a continuous form with two combo boxes. I would like the first combo box to dictate the data shown in the second combo box. Right now, when the customer name in the first combo box is selected, the second combo box displays the ID value for that row in the table and it should show the customer's email address.
The control source for the email combo is set to customer name and row source is as follows: SELECT tblRecipients.Email FROM tblRecipients.
Any idea why ID is pulling up rather than email? Thanks in advance.