It's a Combo Box Question Again!

[pozzy]

Mile-O-Phile. I had a look at the Cascading Comboboxes FAQ. I followed the example and it works fine, thanks. Is there a way of showing ALL as an option in the second combo?

 

[Len Boorman]

One: display selection in the cbo & display the fees in the following texbox

Am I correct in saying that you have achieved the first objective.



TWO: query the 2nd combo box. Am confused.

Do you want to query the second combo or use the result of combo 1 as a criteria in the selections available in combo 2

Len

 

[Mile-O]

Mile-O-Phile. I had a look at the Cascading Comboboxes FAQ. I followed the example and it works fine, thanks. Is there a way of showing ALL as an option in the second combo?

Why would you want to do this? It would defeat the purpose of the cascade.

 

[WarriorMCB]

(Len), I always had the ability to show fees after choosing the product. I just need cbo2 to display a selected list depending on cbo 1 choice. Each cbo needs to do these two things, for example: Product Combo Box choices; letterheads; business cards; flyer... The cbo displays two columns (Product & Fee), upon choosing a selection the product is displayed in Product cbo & the fee shows up the another text box (Named:Fees). Now upon this selction the second cbo need to list ONLY the PrintColorFees for that chosen product. The third cbo need to list the paperstock available for the product chosen (in 1st cbo).

All these cbo's not only need to list selected availablity of different products, it also needs to display the fee for the selection.

The latter is what it does now. However, it shows the entire lists dispite chosen Product!

I don't want to sound confusing. I wish that I could send u a sample but the zip is 123kps so I can't. Please Help me out. I hope i'm making myself clearer.

 

[Len Boorman]

I have senT A pm with an address to which you can email me direct BUT I will not see it until Monday.

Second

You have a selection in Combo 1

You want Combo 2 to offer a choice depending upon Combo 1 That's is not a problem

The process is as described for cascading combos.

Set up combo 2

The row source needs to be amended.

The row source is a query that you can display and then edit.

You need to insert into the criteria row of the query the reference to combo1. The easiest way to do this is using the builder.

Now the combo will not show the values based on combo 1 until it is requeried.

When the form opens the combo boxes are populated. But in this case the values are based upon the value in combo and nothing has been selected yet in combo 1.

So I suggest that the on click property of combo 1 contains an Event Procedure [Combo 2].Requery.

This will then populate combo 2 correctly.

Len