Double Selection combo boxes

[RICHARD BROMBERG]

I have a table which contains a City field and a Street field and some other
fields.

The main form has two combo boxes cmboCity and cmboStreet

I want to select a city from then cmboCity combo box and have the cmboStreet
combo box
populated with the Street from that city.

The program only works one time. That is, I select a city from cmboCity and
the cmboStreet
populates with all the streets in that city.

If I then relelect a differant city from cmboCity there is no change in
CmboStreet. When selected it keeps the old street list.

I have to reload the whole program to select a differant city.

Here are the row sources for each combo box

cmboCity SELECT DISTINCT [city] FROM Mail_List;

cmboStreet SELECT DISTINCT [street] FROM Mail_List WHERE
[Mail_List].[city]=[Forms]![frmMain]![cmboCity];

Any idea what is wrong ??

[Tom van Stiphout]

On Mon, 29 May 2006 13:45:58 GMT, "RICHARD BROMBERG" <no*****@att.ne t>
wrote:

In cmboCity.AfterU pdate event, write:
cmboStreet.Requ ery

-Tom.

I have a table which contains a City field and a Street field and some other
fields.

The main form has two combo boxes cmboCity and cmboStreet

I want to select a city from then cmboCity combo box and have the cmboStreet
combo box
populated with the Street from that city.

The program only works one time. That is, I select a city from cmboCity and
the cmboStreet
populates with all the streets in that city.

If I then relelect a differant city from cmboCity there is no change in
CmboStreet. When selected it keeps the old street list.

I have to reload the whole program to select a differant city.

Here are the row sources for each combo box

cmboCity SELECT DISTINCT [city] FROM Mail_List;

cmboStreet SELECT DISTINCT [street] FROM Mail_List WHERE
[Mail_List].[city]=[Forms]![frmMain]![cmboCity];

Any idea what is wrong ??

[RICHARD BROMBERG]

Tom

Thanks for the help
"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:1q******** *************** *********@4ax.c om...

On Mon, 29 May 2006 13:45:58 GMT, "RICHARD BROMBERG" <no*****@att.ne t>
wrote:

In cmboCity.AfterU pdate event, write:
cmboStreet.Requ ery

-Tom.

I have a table which contains a City field and a Street field and some otherfields.

The main form has two combo boxes cmboCity and cmboStreet

I want to select a city from then cmboCity combo box and have the cmboStreetcombo box
populated with the Street from that city.

The program only works one time. That is, I select a city from cmboCity andthe cmboStreet
populates with all the streets in that city.

If I then relelect a differant city from cmboCity there is no change in
CmboStreet. When selected it keeps the old street list.

I have to reload the whole program to select a differant city.

Here are the row sources for each combo box

cmboCity SELECT DISTINCT [city] FROM Mail_List;

cmboStreet SELECT DISTINCT [street] FROM Mail_List WHERE
[Mail_List].[city]=[Forms]![frmMain]![cmboCity];

Any idea what is wrong ??