combo box to default to first in list

[swmorin]

How do I set a combo box to default to first in list?

 

[John Big Booty]

You can set it in the Form's On Current Event using;

Me.ComboName.DefaultValue = Me.ComboName.ItemData(0)

Our you can set it whilst the form is in design View by Setting the Default Value on the Data tab of the Combo Box property sheet.
Note; you will have to use the value that is held in the Bound column of the Combo, which equates to the first value in the list.

 

[swmorin]

thank you that worked great