Using one Combo Box to control Another

[ajacks]

I am creating a form where I have 2 Combo Boxes. I want to design it so that the when I choose a topic in the first combo box, I want the courses corresponding to that topic to be updated in the second combo box. Do you have any suggestions, as to how I might do this. I referred to the EditProducts form in the Developers solution database but it was a little too complex. Please give me any suggestions you may have A.S.A.P. Thanks

[This message has been edited by ajacks (edited 07-28-2000).]

 

[MICHELE]

That is something I have been working on too. Microsoft Article ID: Q97624 gives an example and explanation on this. I hope it helps you more than it did me.

 

[Ron Bell]

The solution to this problem:

First - delete Controlsource of 1st combo, if it has one.

You could then display any record relating to the ControlSource of this field via another added textbox.

So yr 1st Combo then becomes only related to yr 2nd Combo, and does nothing else
but, with code entered, requery yr 2nd combo, as below.
_____________

In 1st combos "On click" event type:- type: Forms![X]![2ndComboname].Requery

Then in 2nd Combo: Go to Recordsource property and click (3 dots) for query design

in query design, under same ID field; as * 'Bound column' property value in Combo1 -
type as its criteria: Forms![X]![1stComboname]
_______________________

This will not work unless both combos have a same field included in their queries,
this has to be 'Bound' in 1st and thus set as criteria in 2nd, as above.

If you dont have this field you have to change your recordsource query for 2nd combo, to add
relevant field from wherever - you can do this via the ( 3 dots) query designer
(maybe add table with relevant field - and add relationship)

If you have any problems with result pse ask

 

[peterm]

Or
If the after update event of the first box requery the second.
Make the criteria in the recordsource query of the second dependent on the value of the first.