Coerce Combo Box Based On Invidible Column 0?

[(PeteCresswell)]

A combo box's .RowSource for it's 2 columns:
--------------------------------------------
1 Liquidity Fund
2 High Risk Fund
3 Medium Risk Fund
--------------------------------------------

Call it "cboFund".

When a form opens, I want to force cboFUnd to show the "High Risk
Fund" - and have .Column(0).Value=2, but I do not want to code
"High Risk Fund".

I do not want to code a cboFund.DefaultValue.

Seems like I've done this before, but I can't find a code
example.

Anybody?

 

[Tom van Stiphout]

On Sat, 13 Oct 2007 20:01:24 -0400, "(PeteCresswell)" <[email protected]>
wrote:

Me.cboFund.Value = 2
Of course I'm assuming the BoundColumn is 0, the hidden ID column.

-Tom.

 

[(PeteCresswell)]

Per (PeteCresswell):

When a form opens, I want to force cboFUnd to show the "High Risk
Fund" - and have .Column(0).Value=2, but I do not want to code
"High Risk Fund".

I do not want to code a cboFund.DefaultValue.

Seems like I've done this before, but I can't find a code
example.

Oops. Mea Culpa on that last post.

The last cup of coffee must've finally nudged my IQ above room
temperature.

Gotta set cboFund.BoundColumn=1 instead of zero and then a
straight equate does the job as in me.cboFund.Value = 2.