Combobox filter default value before form open

[Stalin]

I have a combobox [me.cmbx_example] who's recordsource is a valid sql
statement which returns a list of usernames on form open.

I have an additional field [me.curr_user] that holds the current
network user name on form open.

I would like to filter the default value to the username that matchs
[me.curr_user].

something like "if me.cmbx.example.defaultvalue =
me.curr_user ....where me.cmbx.example.itemvalue = me.curr_user...."

would I need to loop through the combo values to do this or is there a
filter property I'm not seeing?

Any suggestions are appreciated.

 

[Marshall Barton]

I have a combobox [me.cmbx_example] who's recordsource is a valid sql
statement which returns a list of usernames on form open.

I have an additional field [me.curr_user] that holds the current
network user name on form open.

I would like to filter the default value to the username that matchs
[me.curr_user].

something like "if me.cmbx.example.defaultvalue =
me.curr_user ....where me.cmbx.example.itemvalue = me.curr_user...."

would I need to loop through the combo values to do this or is there a
filter property I'm not seeing?

You can select a row in a combo box by setting its Value.
If the value is not in the list, the ListIndex property will
be -1 and if it is in the list, ListIndex will have the
matching row's rownumber.

 

[Stalin]

I have a combobox [me.cmbx_example] who's recordsource is a valid sql
statement which returns a list of usernames on form open.

I have an additional field [me.curr_user] that holds the current
network user name on form open.

I would like to filter the default value to the username that matchs
[me.curr_user].

something like "if me.cmbx.example.defaultvalue =
me.curr_user ....where me.cmbx.example.itemvalue = me.curr_user...."

would I need to loop through the combo values to do this or is there a
filter property I'm not seeing?

You can select a row in a combo box by setting its Value.
If the value is not in the list, the ListIndex property will
be -1 and if it is in the list, ListIndex will have the
matching row's rownumber.

Perfect,

Thanks
Stalin