Combo Rowlist

T

Tony

I have a combo box which is unbound to any field on the
form, but I have a SQL statement to create a value for
that combox.

My problem is how can I make my first value on my combo
box show up without clicking on dropdown list.

Thanks in advance,
Tony
 
G

Graham Mandeno

Hi Tony

Set the DefaultValue of the combo to:
[Name of combo].[ItemData](0)

If you ever want to set the value back to the default, for example in
Form_Current or Form_BeforeInsert, use this code:
With Me.[Name of combo]
.Value = .ItemData(0)
End With

If the combo has headers then use .ItemData(1)
 
Top