Auto Selection Combo Box

[erinmunley]

I have 2 synchronized combo boxes on a form. The second one lists the
information based on what the user selected from the first combo box.
My problem is that I want the second combo box to automatically select
the first option on the list when the user selects the value from the
first list.



Here's what I've got so far:



1. The user selects a value from the first combo box.



2. Access automatically gives focus to the second combo box, but does
not select any values.



What I want:



1. When the second combo box gets focus, I want it to automatically
select the first option and give focus to the next control (A
text box).



If anyone has any suggestions, I would really appreciate them.

 

[Wayne Morgan]

After the .Requery of the 2nd combo box try

Me.cboCombo2=Me.cboCombo2.Column(0,0)

where the first 0 is the column number (zero based) of the bound column.