You are right. In the copying and pasting I somehow left off the emailaddress. Once, I replaced that in the SQL code everything seemed to go alight. Now I have a included an old version (attached file) of my db that has a combo box with employee name and email addresses on frmEmail. This one works. It is slightly different than yours and I am not sure way it does work. In that version the rowsource takes care of the SQL as well. The email text box just has emailaddress in it. Yet it works.
I have one question: why put the SQL code in rowsource and not control source? Is it because control source must be left blank?
Also, I know that professionals do not use them, but could the combo box wizard create the row SQL code for this? I am just wondering.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed
I