Thank you for the references. i was able to get it somewhat doing what I want. However it is still using a combobox. So when the user selects their name they still have to select therei email address from the a drop down but theirs is the only email in the list. Here is the code I used in the 2nd combobox. Not sure how to get it to work with a text box to just autofill.
Code:
SELECT tbl_Requestor.email FROM tbl_Requestor
WHERE (((tbl_Requestor.RequestorName)=[forms]![frmCustomer].[cboRequestorName]))
GROUP BY tbl_Requestor.email
ORDER BY tbl_Requestor.email;
I did this with the query builder as the datapig site suggested I am just unable to get it to autofill without having to select it.