Goto First record in ComboBox

[StuartDwight]

I have two ComboBoxes on a form, the second Combobox's citeria is based upon the record chosen in the first ComboBox.
What I am Trying to do is on the AfterUpdate Event on the first ComboBox, to automaticaly show the first value in the second ComboBox.
Many Thanks,
Stu.

 

[RuralGuy]

What does "...automaticaly show the first value in the second ComboBox" mean to you? Do you want the 2nd cbo to do something?

 

[StuartDwight]

I want the 2nd Combo to lookup all the records it would if you clicked it and goto the first one.

 

[RuralGuy]

I sounds like your 2nd ComboBox should be your 1st ComboBox!!

 

[StuartDwight]

Sorry I don't think i have explained it very well.
The first combo box contains a list of Agencies and the second combo contains a list of people working for the Agencys, the citeria of the second combo (or people) is based upon the agency picked from the agency combo (first).
What i wanted to know is on the after update event of the first combo can I go straight to the first record in the second combo box.
I hope that makes more sense,
Stu.

 

[RuralGuy]

Let's see if I have this correct. You want the second cbo to go to the agent record of the agent select in the cbo, which you do in the AfterUpdate event of the 2nd cbo. You want the 1st cbo to select the Agency that the 2nd cbo displays agents of and *also* go to the 1st agent if the 2nd cbo. If that is correct then in the AfterUpdate event of the 1st cbo, requery the 2nd cbo and basically duplicate the code that is in the AfterUpdate event of the 2nd cbo. This is a rather strange way to manipulate cascading combo boxes.