Populating Combo Box from db 1

[LucyL]

Hello
I have populated a Combo box through a SQL query but I want the first value returned to be defaulted in to the actual combo box instead of blank.
Can anyone help?

 

[johnwm]

I notice that although you have asked lots of questions, you don't seem to have responded to many of the answers given. If the answers were not satisfactory, look at faq222-2244 to see how to ask more productive questions.

If they were helpful, see faq222-2244 paragraph 15 & 16 to see how to acknowledge helpful posts, and how to reply to others' questions.

For this question, if the first item (ListIndex 0) in the combo is blank try:

myCombo.ListIndex = 1

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[LucyL]

Thanks Johnny very helpful!

 

[johnwm]

You're most welcome, and Thank you!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'