Combo Rowlist

  • Thread starter Thread starter Tony
  • Start date Start date
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
 
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)
 
Back
Top