Code:
Private Sub GetEMailAddresses(strQuery As String) Set dbFranchise = CurrentDb() Set qdfEMails = dbFranchise.QueryDefs(strQuery)
This subroutine is being called in another sub where strQuery is also being set.
Code:
For Each varQuery In .ItemsSelected strQuery = strEMailQueryPrefix & .Column(0, varQuery) Call GetEMailAddresses(strQuery) Next varQuery
Comment