Select first option in a dropdown box - by using VBA ?

[StevenSkinner]

Hello,

I need to select the first option automatically in my Combo Box using VBA, Any Ideas ???

p.s. the combo box is linked to a table

 

[SydneyGeek]

Do you mean that when you open a form, you want to see something selected in the combo -- a default value?

Denis

 

[StevenSkinner]

I don't think it's going to be a default Value (Although I could be wrong)

because the combo box get's requery'd it could have any values inside it, so I want it to display the first value in the combo box after its been requery'd ??

Any Ideas

 

[SydneyGeek]

Hmmm...

Would a ListBox be suitable? You can make it 2-3 rows high to restrict the space, but I often find them quicker than Combos for choosing from a range of options.

Denis