Autofill Combo Box with First Item in List

[Carrion]

Does anyone have a code that will auto fill a combo box, with the first item in its list?

I have a combo box looking up its info in a query, and that query is looking up info based on a field on the same form as the combo box. I want to have the combo box auto fill on lost focus.

thanks

 

[PHV]

Something like this ?
If yourCombo.ListIndex = -1 Then yourCombo.ListIndex = 0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244