RE: combo box default selection

Its further down the list but is the one highlighted.

"Klatuu" wrote:

> When you say "defaulting to", do you mean it is at the top of the list? or
> the item is further down in the list, and it is the one highlighted?
>
> "Kevin R" wrote:
>
> > Not as confused as me. You saw my code earlier, I have the rowsource set to
> > order by OfficeName and the list is in order by OfficeName but for some
> > reason the combo box is not defaulting to the first item in the list but
> > rather the first item I entered into the table that the list is being created
> > from.
> >
> > "Klatuu" wrote:
> >
> > > Now I'm confused. It the rowsource has been sorted alphabetically, why is
> > > the first row not the first entry in the table in the sort order?
> > >
> > > "Kevin R" wrote:
> > >
> > > > I've done that but it is still select the first value in the first row of the
> > > > table rather than the first value in the list which has been sorted
> > > > alphabetically.
> > > >
> > > > "Klatuu" wrote:
> > > >
> > > > > Put it in the default value property of the combo box.
> > > > >
> > > > > "Kevin R" wrote:
> > > > >
> > > > > > Sorry I'm new to Access so I may need a little more help. For my RowSource
> > > > > > this is what I have now:
> > > > > >
> > > > > > SELECT tblOfficeInfo.OfficeName FROM tblOfficeInfo ORDER BY
> > > > > > tblOfficeInfo.OfficeName;
> > > > > >
> > > > > > If I look at the SQL View it shows:
> > > > > >
> > > > > > SELECT tblOfficeInfo.OfficeName
> > > > > > FROM tblOfficeInfo
> > > > > > ORDER BY tblOfficeInfo.OfficeName;
> > > > > >
> > > > > > So where do I fit your line in at?? Thanks.
> > > > > >
> > > > > > "Klatuu" wrote:
> > > > > >
> > > > > > > Me.cboMyCombo.ListIndex = 0
> > > > > > >
> > > > > > > "Kevin R" wrote:
> > > > > > >
> > > > > > > > I have a form with a combo box on it that is populated with items from
> > > > > > > > another table. I have it so that it is sorted alphabetically but rather than
> > > > > > > > the first item in the list being selected as the default choice, it select
> > > > > > > > the first item I entered into the table as the default selection. How do I
> > > > > > > > make it always default to the first item in the combo list?
> > > > > > > >
> > > > > > > > thanks.
.