L
lilyjiangyoung
I am a newbee to ADP. I am so used to the idea of .mdb, now I have trouble
working with ADP.
Question 1. How can I use two combo boxes(tiered, one is Region, the other
is County, a region has many counties) to select corresponding report?
I want the user to select Region first, then the corresponding counties
shown in the cboCounty combobox.
Question 2. (continued) After I select a county, then I want to mail the
corresponding report to agents in this county.
I have a table with fields "Region", "County", "Agent", and "Email". I
want to open this table with a criteria County equal to
"Forms!AgtReportControl!cboCounty", then use a loop to add all agent's
email address to a string, lets call it strAccount. Finally I want to use
DoCmd.SendObject acReport, strAccount
to send the email.
But I couldn't do it.
Thanks very much for your help.
lily
working with ADP.
Question 1. How can I use two combo boxes(tiered, one is Region, the other
is County, a region has many counties) to select corresponding report?
I want the user to select Region first, then the corresponding counties
shown in the cboCounty combobox.
Question 2. (continued) After I select a county, then I want to mail the
corresponding report to agents in this county.
I have a table with fields "Region", "County", "Agent", and "Email". I
want to open this table with a criteria County equal to
"Forms!AgtReportControl!cboCounty", then use a loop to add all agent's
email address to a string, lets call it strAccount. Finally I want to use
DoCmd.SendObject acReport, strAccount
to send the email.
But I couldn't do it.
Thanks very much for your help.
lily