ComboBox - Default Value - Urgent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Thanks in advance

Want to make the default value the first value in the list.

How woould I code this.

Thanks

Trev
 
hi Trevor,

Trever said:
Want to make the default value the first value in the list.
How woould I code this.
Click to expand...
Fill the RowSource with a value list (.RowSource="DefVal";"...";"...")
in VBA and set the corresponding RowSourceType.

Otherwise add an order column in your RowSource table.


mfG
--> stefan <--
 
Trever said:
Want to make the default value the first value in the list.

How woould I code this.
Click to expand...


Use the form's Load event to set the default value:

Me.combobox.DefaultValue = """" & Me.combobox.ItemData(0) &
""""

If the combobox's bound column is a Numeric type field, then
drop the quotes.
 
Back
Top