Sending Email via button in Form

J

Jonathan

OK here is the scenario. I have a table, "SMEInfo", with the field "Email".
The "SMEInfo"table has a primary key of "SMEID". The "SMEName" is selected
from a dropdown box and stored in "SMEStatusTable" in the field "SMEDesc".
The dropdown box is in a subform that is connected to the primary form via
"CaseID#". My issue is that I want to have the "Email" to populate in the
"TO" area of an email for the current record only. I can't seem to get
Access to recognize the current record that has the same "CaseID#" in Both
the Primary table and "SMEStatusTable" to return the "Email" address that is
associated. Oh, just in case anyone is wondering, the reason that the data
is stored in another table is because there can be several "SME"s for any
single case.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Help creating a search form in Access XP 0
Append Crosstab Query to Existing Table 0
sqlite-odbc write conflict 2
Mail Merge skipping records/sending one at a time 0
Office 365 Email Encryption One time Passcode 0
Assign multiple people to one record - easily 3
Creating a Search using a combo box and then creating a report. 4

Top