Combo box

[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

 

[Ki Yi [MS]]

Hello,

Try the following article for your question 1:

ACC2000: How to Synchronize Two Combo Boxes on a Form WGID:147
ID: 209595.KB.EN-US
http://support.microsoft.com/?kbid=209595

Ki