Question about Cascading Combo Boxes

[EmAlbritton]

Hi all. I am a rookie, and trying to get my head around the cascading combo
boxes. I have searched and read a lot of the other posts on this topic, and
none seem to either make sense or make it work for me. My situation is this:

Tables: Markets, Collectors, Clients
Fields: Markets.Market, Collectors.Collector, Clients.Company Name
Combos: Market, Collector, Client

Form: 4-Call Log Entry

I am trying to select Market, and cascade to specific choices for both
Collector and Client.

The latest that I have tried is below.

Row Source for Market is: SELECT Markets.Market FROM Markets;

Row Source for Collector is: SELECT DISTINCTROW Collectors.Collector FROM
Collectors WHERE (((Markets.Market) Like forms![frm4-Call Log Entry]!Market))
;

Haven't yet done anything with the Client as I can't get the first two to
work.

Oh...after making this last change, my choices for Market went away. The
combo box is completely blank now.

Any help would be greatly appreciated.

Emily

 

[pietlinden]

Read this:
http://www.mvps.org/access/forms/frm0028.htm

 

[EmAlbritton via AccessMonster.com]

Thanks for the link......I played with that code and couldn't make it work.

I did find another post here that looked like something I have tried before
(one late night or another) that I finally managed to get working.

Thanks again for your time and everyone else here that helps out all of us
rookies. I will be back again I am sure.

Em

 

[Guest]

Can you tell me what you found? Tried this fix too & can't get it to work.
I'm having the same combobox problem. Very frustrating.

thx
seana

 

[EmAlbritton via AccessMonster.com]

Seana-

Sorry I didn't get back here sooner.....

Here is how I got my combos to work....

Example is as follows:
Form-EntryForm
Table-Markets (fields are MarketID and Market)
Table-Clients (fields are Client ID, Client and Market)
cmbo-Market (this is my main combo...the one that decides everything else...
choices here come from Table-Market)
cmbo-Clients (this combo is limited by the choice made in cmbo-Market...
choices here come from Table-Clients)

The RowSource for the cascading Combo Box is:

SELECT [Table-Clients].Client FROM [Table-Clients] WHERE ((([Table-Clients].
Market)=Forms![Form-EntryForm]!cmbo-Market));

Let me know if this is clear as mud.

Emily

Can you tell me what you found? Tried this fix too & can't get it to work.
I'm having the same combobox problem. Very frustrating.

thx
seana

Thanks for the link......I played with that code and couldn't make it work.

[quoted text clipped - 8 lines]

 

[EmAlbritton via AccessMonster.com]

One other thing I forgot...

Need an AfterUpdate Event on my cmbo-Market that is as follows:

Me.cmbo-Clients.requery

EA

Seana-

Sorry I didn't get back here sooner.....

Here is how I got my combos to work....

Example is as follows:
Form-EntryForm
Table-Markets (fields are MarketID and Market)
Table-Clients (fields are Client ID, Client and Market)
cmbo-Market (this is my main combo...the one that decides everything else...
choices here come from Table-Market)
cmbo-Clients (this combo is limited by the choice made in cmbo-Market...
choices here come from Table-Clients)

The RowSource for the cascading Combo Box is:

SELECT [Table-Clients].Client FROM [Table-Clients] WHERE ((([Table-Clients].
Market)=Forms![Form-EntryForm]!cmbo-Market));

Let me know if this is clear as mud.

Emily

Can you tell me what you found? Tried this fix too & can't get it to work.
I'm having the same combobox problem. Very frustrating.

[quoted text clipped - 7 lines]

 

[Guest]

Emily
thanks so much for the response.
I'll plug it in & give it a whirl.

Seana

One other thing I forgot...

Need an AfterUpdate Event on my cmbo-Market that is as follows:

Me.cmbo-Clients.requery

EA

Seana-

Sorry I didn't get back here sooner.....

Here is how I got my combos to work....

Example is as follows:
Form-EntryForm
Table-Markets (fields are MarketID and Market)
Table-Clients (fields are Client ID, Client and Market)
cmbo-Market (this is my main combo...the one that decides everything else...
choices here come from Table-Market)
cmbo-Clients (this combo is limited by the choice made in cmbo-Market...
choices here come from Table-Clients)

The RowSource for the cascading Combo Box is:

SELECT [Table-Clients].Client FROM [Table-Clients] WHERE ((([Table-Clients].
Market)=Forms![Form-EntryForm]!cmbo-Market));

Let me know if this is clear as mud.

Emily

Can you tell me what you found? Tried this fix too & can't get it to work.
I'm having the same combobox problem. Very frustrating.

[quoted text clipped - 7 lines]

Read this:
http://www.mvps.org/access/forms/frm0028.htm