displaying data in combo box

I have a list box and a combo box referencing the same field to be displayed (the users want both option to locate a record). In my list box items are displayed as soon as  the form open. In my combo box when the form opens no data is displayethe samed until after I click on the control. I would like to show data in my combo box when the form opens like it does in a list box
Frank FreeseAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
> there is no value in the control source.
> I would like to show data in my combo box when the form opens

These two statments are mutually exclusive.  

Unless you mean you want the combo box records viewable when the form opens, which would be in VBA code..

Me.YourComboBoxName.Dropdown
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
If the value in the Control Source of the combo box matches any of the values in its Row Source, Bound Column, then the value should appear when the form opens.
0
 
Frank FreeseAuthor Commented:
there is no value in the control source. i used the combo wizard to look up a record based upon a value i select from my combo box.
0
All Courses

From novice to tech pro — start learning today.