Presetting a combobox ???

[ksor]

I have a combobox populated with items from a table.



I want the form to show records with the value from the combobox i a specific field - and it works ... sort of !

I want to PRESET the combobox to the FIRST item and I use this code to do it:

cboHType.SetFocus
cboHType.Selected(0) = True

But in whitch event should I place the presetting code ?

I have tried Load, Open, Current ... non of them gives the result I want

[Missinglinq]

Not exactly sure of your intent, here, but it's not where you're placing it, it's that you're missing a line of code:

Me.cboHType.SetFocus
Me.cboHType.Dropdown
Me.cboHType.Selected(0) = True

That'll work wherever you want it to, I think, but if you expect the same thing to happen in doing this, as it would if you physically made a selection from the Combobox, you'll need to call that event (presumably the cboHType_Afterupdate event) as well.

Me.cboHType.SetFocus
Me.cboHType.Dropdown
Me.cboHType.Selected(0) = True
Call cboHType_AfterUpdate

Linq ;0)>

[ksor]

Thx ... the dropdown did the trick there - now the first item is shown.

... and the AfterUpdate works too !

Thx !

[Missinglinq]

Glad we could help!

Linq ;0)>