Bmelville1
Registered User.
- Local time
- Today, 01:51
- Joined
- Jun 18, 2012
- Messages
- 10
Hello,
I have created a database for Issues at work and when a new issue is created I want to email the correct people. I have it working for the creator the support person assigned, but I cannot get it to work for the technician(s) assigned as in my neewbie ignorance I used a multi-value combo box. I have a query that will look at the techs and get the email addresses based on the Issue ID but DLOOKUP only returns the first matching address is there a way I can LOOP through and get the address for each row that matches the issue ID? I use a tempvars called TempID for my query. my lookup looks like this
strTo = DLookup("EmailAddress", "TechAssigned", "ID =" & TmpID)
and this goes to
.To = strTo
Thanks for all your help.
I have created a database for Issues at work and when a new issue is created I want to email the correct people. I have it working for the creator the support person assigned, but I cannot get it to work for the technician(s) assigned as in my neewbie ignorance I used a multi-value combo box. I have a query that will look at the techs and get the email addresses based on the Issue ID but DLOOKUP only returns the first matching address is there a way I can LOOP through and get the address for each row that matches the issue ID? I use a tempvars called TempID for my query. my lookup looks like this
strTo = DLookup("EmailAddress", "TechAssigned", "ID =" & TmpID)
and this goes to
.To = strTo
Thanks for all your help.
