I am creating an audit application to track the auditing of required files and tasks for clients. I have a Client table and a Staff table. I can assign a staff person to a client via two combo boxes in a Audit Form. One combo box pulls from the Name field in the Client Table. The other combo box pulls from the Name Field in the Staff Table. Once I select and assign a staff name to a client, I want to email the staff person from the Audit Form. However, I am unable to display the Staff persons email address in the Audit Form. I tried building a new form from a query with no success. I am fairly new to Access, so I am guessing this is a simple fix that I am missing.

Thanks for your help in advance.