Connecting Tech Pros Worldwide Help | Site Map

Default combo box line

  #1  
Old November 13th, 2005, 02:27 PM
Rod Speed
Guest
 
Posts: n/a
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 ?


  #2  
Old November 13th, 2005, 02:27 PM
Wayne Morgan
Guest
 
Posts: n/a

re: Default combo box line


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]


  #3  
Old November 13th, 2005, 02:27 PM
Rod Speed
Guest
 
Posts: n/a

re: Default combo box line


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]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box using lookup values default to first value, not to parent table value northshore answers 0 July 29th, 2006 01:05 AM
Combo box default value carmela_wong@hotmail.com answers 6 June 6th, 2006 07:45 PM
How to control the size(width of a combo box generated in asp?) Jack answers 8 March 10th, 2006 03:25 PM
DoCmd.RunSQL() not reading variable from combo box Richard Hollenbeck answers 7 November 13th, 2005 02:15 AM