Combo boxes and search

[pb21]

I have a combo that uses a query to show countries and the related mother tongue ref if in another column.

I want an after update after selection of the country that will select the appropriate language in another combo.

The second combo uses a query to look up the list of languages available, it would be nice for this selection to be made automatically but allow the user to change it in case they use another language.

I am not sure how to find the list of entries in a combo in vba.

hope I have explained ok

regards in advance.

Peter

 

[pb21]

found solution

I worked it out for myself with:

Me.CBMotherTongue.Value = Me.CBCountry.Column(2)

Thanks anyway for looking