Combo box default?

[chris-uk-lad]

Hi all,

I cant seem to work out how to get a combo box to display a value on loading the form. I want the Name John to be the default value on the list when the form loads up.

I have tried the following to no such luck.

cboName.ListIndex = 0 
Me.cboName.DefaultValue = "John"

Thanks

 

[missinglinq]

Me.cboName = Me.cboName.ItemData(0) assuming that John is the first item in the combobox.

I believe the ListIndex property is Read-Only and cannot be set and I suspect the problem with Me.cboName.DefaultValue = "John" is that the DefaultValue only comes into play when a new record is generated. A simple Me.cboName.Value = "John" or Me.cboName = "John" (which is the same thing) should also work.

 

[chris-uk-lad]

worked a treat, ty

 

[missinglinq]

Glad to help!

Linq

 

[Poseidon1]

Glad to help!

Linq

Thanks..I benefited from your guide too!!

 

[missinglinq]

A two-fer! Always nice!