Default combo box line

OK, I've got a form that works fine with the user selecting a combo box entry
that is required, manually.

I want to set the default when the form is opened so you only need to do that if
the default isnt what you want.

I dont want it to be the first item in the list, tho that would be a viable
kludge.

How do I do that ?

Set the Default Value of the combo box to the value in the Bound Column for
the row you want to be the default.

--
Wayne Morgan
MS Access MVP


"Rod Speed" <rod_speed@yahoo.com> wrote in message
news:3o7dhvF4jan1U1@individual.net...[color=blue]
> OK, I've got a form that works fine with the user selecting a combo box
> entry
> that is required, manually.
>
> I want to set the default when the form is opened so you only need to do
> that if
> the default isnt what you want.
>
> I dont want it to be the first item in the list, tho that would be a
> viable kludge.
>
> How do I do that ?
>[/color]

Wayne Morgan <comprev_gothroughthenewsgroup@hotmail.com> wrote
[color=blue]
> Set the Default Value of the combo box to the value in the Bound Column for
> the row you want to be the default.[/color]

Thanks, thought it had to be something obvious like that.
[color=blue]
>
> "Rod Speed" <rod_speed@yahoo.com> wrote in message
> news:3o7dhvF4jan1U1@individual.net...[color=green]
>> OK, I've got a form that works fine with the user selecting a combo
>> box entry
>> that is required, manually.
>>
>> I want to set the default when the form is opened so you only need
>> to do that if
>> the default isnt what you want.
>>
>> I dont want it to be the first item in the list, tho that would be a
>> viable kludge.
>>
>> How do I do that ?[/color][/color]