I'm not sure i understand the issue correctly, you say that the email address text box is supposed to get it's value from a recordset? The initial value of the text box is not configured to use a recordset.
you then say if you fill in the text box it works...
since it works if you fill in the text box, i am confused by your last message questioning the Email server, if it works by filling in the text box, the email server you are using should be fine.